APPS.PV_CONTACT_USER_BATCH_PUB dependencies on FND_RESPONSIBILITY

Line 302: FND_RESPONSIBILITY_VL FR,

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
306: AND FR.APPLICATION_ID = UT.APPLICATION_ID

Line 1418: FND_RESPONSIBILITY_VL FR,

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
1422: AND FR.APPLICATION_ID = UT.APPLICATION_ID

Line 1479: from fnd_responsibility

1475:
1476:
1477: cursor resp_list(l_usertype_id VARCHAR2) is
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

Line 2024: FND_RESPONSIBILITY_VL FR,

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
2028: AND FR.APPLICATION_ID = UT.APPLICATION_ID

Line 2087: from fnd_responsibility

2083:
2084:
2085: cursor resp_list(l_usertype_id VARCHAR2) is
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