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_USER_MGMT_PVT dependencies on JTF_AUTH_DOMAINS_B

Line 891: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_role_perms jtfrp,

887:
888:
889: cursor check_curr_user_perms(l_role_id JTF_NUMBER_TABLE, l_user_name varchar2) IS
890: Select jtfperm.permission_name
891: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_role_perms jtfrp,
892: jtf_auth_permissions_b jtfperm
893: where jtfp1.principal_name = l_user_name
894: and jtfp1.is_user_flag=1
895: and jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id

Line 1996: select 1 from jtf_auth_principal_maps jtfpm,jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,

1992: and (hzr.end_date is null or hzr.end_date > sysdate)
1993: and hzr.object_id = pvpp.partner_party_id
1994: and pvpp.status = 'A' and exists
1995: (
1996: select 1 from jtf_auth_principal_maps jtfpm,jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
1997: jtf_auth_principals_b jtfp2,jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
1998: where jtfp1.principal_name = RES.user_name and jtfp1.is_user_flag=1
1999: and jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id and jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id
2000: and jtfp2.is_user_flag=0 and jtfp2.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id