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_PRINCIPAL_MAPS

Line 1481: and exists(select 1 from jtf_auth_principal_maps jtfpm,

1477: and pr2.party_id = pj.source_id
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

Line 1499: from jtf_auth_principal_maps jtfpm,

1495: and jtfd.domain_name='CRM_DOMAIN' );
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