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.

[Home] [Help]

APPS.PV_USER_MGMT_PVT dependencies on JTF_UM_USERTYPE_ROLE

Line 466: from jtf_um_usertype_role jtur

462: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id
463: and jtfperm.permission_name in (G_PARTNER_PERMISSION, G_PRIMARY_PERMISSION)
464: and jtfp1.principal_name IN
465: (select principal_name
466: from jtf_um_usertype_role jtur
467: where jtur.usertype_id = l_user_type_id
468: and (jtur.effective_end_date is null or jtur.effective_end_date > sysdate)
469: union all
470: select jtsr.principal_name

Line 685: from jtf_um_usertype_role jtur

681: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id
682: and jtfperm.permission_name in (G_PARTNER_PERMISSION, G_PRIMARY_PERMISSION)
683: and jtfp1.principal_name IN
684: (select principal_name
685: from jtf_um_usertype_role jtur
686: where jtur.usertype_id = l_user_type_id
687: and (jtur.effective_end_date is null or jtur.effective_end_date > sysdate)
688: union all
689: select jtsr.principal_name

Line 2083: from jtf_um_usertype_role jtur

2079: and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id
2080: and jtfperm.permission_name = 'PV_PARTNER_USER'
2081: and jtfp1.principal_name IN
2082: (select principal_name
2083: from jtf_um_usertype_role jtur
2084: where jtur.usertype_id = c_usertype_id
2085: and (jtur.effective_end_date is null or jtur.effective_end_date > sysdate)
2086: union all
2087: select jtsr.principal_name