APPS.PV_BENFT_STATUS_CHANGE dependencies on JTF_AUTH_PERMISSIONS_B

Line 1484: jtf_auth_permissions_b jtfperm

1480: and (usr.end_date > sysdate OR usr.end_date IS NULL)
1481: and exists(select 1 from jtf_auth_principal_maps jtfpm,
1482: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
1483: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
1484: jtf_auth_permissions_b jtfperm
1485: where PJ.user_name = jtfp1.principal_name
1486: and jtfp1.is_user_flag=1
1487: and jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id
1488: and jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id

Line 1502: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,

1498: select usr.user_name
1499: from jtf_auth_principal_maps jtfpm,
1500: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
1501: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
1502: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,
1503: fnd_user usr
1504: where PJ.user_name = jtfp1.principal_name
1505: and pj.category = 'EMPLOYEE'
1506: and usr.user_id = pj.user_id