APPS.PV_CONTACT_USER_BATCH_PUB dependencies on JTF_UM_USERTYPE_RESP

Line 301: FROM JTF_UM_USERTYPE_RESP UT,

297: CURSOR CHECK_PARTNER(l_party_id VARCHAR2) IS
298: select partner_id, party_name from pv_partner_profiles,hz_parties where partner_party_id=l_party_id and party_id=partner_party_id;
299:
300: CURSOR USERTYPE_RESP(user_type VARCHAR2) is select FR.RESPONSIBILITY_ID, UT.APPLICATION_ID, FR.VERSION
301: FROM JTF_UM_USERTYPE_RESP UT,
302: FND_RESPONSIBILITY_VL FR,
303: JTF_UM_USERTYPES_B c
304: WHERE c.usertype_key=user_type
305: and UT.USERTYPE_ID = c.usertype_id

Line 1417: FROM JTF_UM_USERTYPE_RESP UT,

1413:
1414:
1415:
1416: CURSOR USERTYPE_RESP(user_type VARCHAR2) is select FR.RESPONSIBILITY_ID, UT.APPLICATION_ID, FR.VERSION
1417: FROM JTF_UM_USERTYPE_RESP UT,
1418: FND_RESPONSIBILITY_VL FR,
1419: JTF_UM_USERTYPES_B c
1420: WHERE c.usertype_key=user_type
1421: and UT.USERTYPE_ID = c.usertype_id

Line 1482: from jtf_um_usertype_resp jtur

1478: select responsibility_id, application_id
1479: from fnd_responsibility
1480: where responsibility_key in
1481: (select responsibility_key
1482: from jtf_um_usertype_resp jtur
1483: where jtur.usertype_id = l_usertype_id
1484: and (jtur.effective_end_date is null or jtur.effective_end_date > sysdate)
1485: union
1486: select responsibility_key

Line 2023: FROM JTF_UM_USERTYPE_RESP UT,

2019:
2020:
2021:
2022: CURSOR USERTYPE_RESP(user_type VARCHAR2) is select FR.RESPONSIBILITY_ID, UT.APPLICATION_ID, FR.VERSION
2023: FROM JTF_UM_USERTYPE_RESP UT,
2024: FND_RESPONSIBILITY_VL FR,
2025: JTF_UM_USERTYPES_B c
2026: WHERE c.usertype_key=user_type
2027: and UT.USERTYPE_ID = c.usertype_id

Line 2090: from jtf_um_usertype_resp jtur

2086: select responsibility_id, application_id
2087: from fnd_responsibility
2088: where responsibility_key in
2089: (select responsibility_key
2090: from jtf_um_usertype_resp jtur
2091: where jtur.usertype_id = l_usertype_id
2092: and (jtur.effective_end_date is null or jtur.effective_end_date > sysdate)
2093: union
2094: select responsibility_key