DBA Data[Home] [Help]

APPS.PV_CONTACT_USER_BATCH_PUB dependencies on FND_RESPONSIBILITY_VL

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 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