select papf.person_number,
--pu.username,
prd.role_common_name
from
per_users pu,
per_user_roles pr,
per_roles_dn prd ,
per_all_people_f papf
where 1=1
and papf.person_id = pu.person_id
and pu.user_id = pr.user_id
and pr.role_id = prd.role_id
--and papf.person_number = '119802'
--and prd.role_common_name ='PAYROLL_SPECIALIST_DATA'
--pu.username,
prd.role_common_name
from
per_users pu,
per_user_roles pr,
per_roles_dn prd ,
per_all_people_f papf
where 1=1
and papf.person_id = pu.person_id
and pu.user_id = pr.user_id
and pr.role_id = prd.role_id
--and papf.person_number = '119802'
--and prd.role_common_name ='PAYROLL_SPECIALIST_DATA'
Nice blog Thanks For Sharing This Informative Blog, In This Blog content is very informative.
ReplyDeleteOracle Fusion Financials Online Training
Oracle Fusion SCM Online Training
Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Project Portfolio Management Cloud. Actually, I was looking for the same information on internet for
ReplyDeleteOracle PPM Cloud Training and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about Oracle Cloud Applications
.