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_RESP_PVT dependencies on JTF_AUTH_PRINCIPAL_MAPS

Line 249: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

245: AND fndu.start_date <= sysdate
246: AND (fndu.end_date is null or fndu.end_date > sysdate)
247: AND exists (
248: SELECT jtfp1.principal_name username
249: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
250: WHERE jtfp1.is_user_flag=1
251: AND jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id
252: AND jtfp2.jtf_auth_principal_id=jtfpm.jtf_auth_parent_principal_id
253: AND jtfp2.is_user_flag=0

Line 288: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

284: AND fndu.start_date <= sysdate
285: AND (fndu.end_date is null or fndu.end_date > sysdate)
286: AND exists (
287: SELECT jtfp1.principal_name username
288: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
289: WHERE jtfp1.is_user_flag = 1
290: AND jtfp1.jtf_auth_principal_id = jtfpm.jtf_auth_principal_id
291: AND jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id
292: AND jtfp2.is_user_flag = 0

Line 827: FROM jtf_auth_principal_maps jtfpm,

823: )
824: IS
825: CURSOR get_user_role IS
826: SELECT jtfperm.permission_name
827: FROM jtf_auth_principal_maps jtfpm,
828: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
829: jtf_auth_principals_b jtfp2,
830: jtf_auth_role_perms jtfrp,
831: jtf_auth_permissions_b jtfperm,

Line 5680: FROM jtf_auth_principal_maps jtfpm,

5676: AND fndu.start_date <= sysdate
5677: AND (fndu.end_date is null or fndu.end_date > sysdate)
5678: AND exists (
5679: SELECT jtfp1.principal_name username
5680: FROM jtf_auth_principal_maps jtfpm,
5681: jtf_auth_principals_b jtfp1,
5682: jtf_auth_domains_b jtfd,
5683: jtf_auth_principals_b jtfp2,
5684: jtf_auth_role_perms jtfrp,

Line 5724: FROM jtf_auth_principal_maps jtfpm,

5720: AND fndu.start_date <= sysdate
5721: AND (fndu.end_date is null or fndu.end_date > sysdate)
5722: AND exists (
5723: SELECT jtfp1.principal_name username
5724: FROM jtf_auth_principal_maps jtfpm,
5725: jtf_auth_principals_b jtfp1,
5726: jtf_auth_domains_b jtfd,
5727: jtf_auth_principals_b jtfp2,
5728: jtf_auth_role_perms jtfrp,