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 684: from jtf_um_usertype_role jtur

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

Line 2081: from jtf_um_usertype_role jtur

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