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_ROLE_PVT dependencies on JTF_UM_SUBSCRIPTION_ROLE

Line 47: from jtf_um_subscriptions_b jusb, jtf_um_subscription_role jusr

43: and (effective_end_date is null or effective_end_date > sysdate) ;
44:
45:
46: cursor primary_enroll_roles is select jusr.principal_name
47: from jtf_um_subscriptions_b jusb, jtf_um_subscription_role jusr
48: where subscription_key = L_ENRLTYPE_KEY
49: and jusb.subscription_id = jusr.subscription_id
50: and jusr.effective_start_date <= sysdate
51: and nvl(jusr.effective_end_date, sysdate) >= sysdate

Line 57: from jtf_um_subscriptions_b jusb, jtf_um_subscription_role jusr

53: and nvl(jusb.effective_end_date, sysdate) >= sysdate
54: and jusb.enabled_flag = 'Y';
55:
56: cursor business_enroll_roles is select jusr.principal_name
57: from jtf_um_subscriptions_b jusb, jtf_um_subscription_role jusr
58: where subscription_key = L_ENRLTYPE_KEY
59: and jusb.subscription_id = jusr.subscription_id
60: and jusr.effective_start_date <= sysdate
61: and nvl(jusr.effective_end_date, sysdate) >= sysdate