APPS.PV_USER_MGMT_PVT dependencies on JTF_UM_USERTYPE_SUBSCRIP

Line 471: from jtf_um_usertype_subscrip jtus, jtf_um_subscription_role jtsr

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
471: from jtf_um_usertype_subscrip jtus, jtf_um_subscription_role jtsr
472: where jtus.usertype_id = l_user_type_id
473: and (jtus.effective_end_date is null or jtus.effective_end_date > sysdate)
474: --and jtus.subscription_flag = 'IMPLICIT'
475: and jtus.subscription_flag in ('IMPLICIT', 'DELEGATION_SELFSERVICE')

Line 690: from jtf_um_usertype_subscrip jtus, jtf_um_subscription_role jtsr

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
690: from jtf_um_usertype_subscrip jtus, jtf_um_subscription_role jtsr
691: where jtus.usertype_id = l_user_type_id
692: and (jtus.effective_end_date is null or jtus.effective_end_date > sysdate)
693: --and jtus.subscription_flag = 'IMPLICIT'
694: and jtus.subscription_flag in ('IMPLICIT', 'DELEGATION_SELFSERVICE')

Line 2088: from jtf_um_usertype_subscrip jtus, jtf_um_subscription_role jtsr

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
2088: from jtf_um_usertype_subscrip jtus, jtf_um_subscription_role jtsr
2089: where jtus.usertype_id = c_usertype_id
2090: and (jtus.effective_end_date is null or jtus.effective_end_date > sysdate)
2091: --and jtus.subscription_flag = 'IMPLICIT'
2092: and jtus.subscription_flag in ('IMPLICIT', 'DELEGATION_SELFSERVICE')