eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_BENFT_STATUS_CHANGE dependencies on JTF_AUTH_PRINCIPALS_B

Line 1482: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,

1478: and pj.category = 'PARTY'
1479: and usr.user_id = pj.user_id
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

Line 1483: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,

1479: and usr.user_id = pj.user_id
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

Line 1500: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,

1496:
1497: cursor lc_get_int_super_users(pc_permission varchar2) is
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

Line 1501: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,

1497: cursor lc_get_int_super_users(pc_permission varchar2) is
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'