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_id = jtsr.subscription_id

Line 689: from jtf_um_usertype_subscrip jtus, jtf_um_subscription_role jtsr

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

Line 2086: from jtf_um_usertype_subscrip jtus, jtf_um_subscription_role jtsr

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