APPS.PV_CONTACT_USER_BATCH_PUB dependencies on HZ_CUST_ACCOUNT_ROLES

Line 323: SELECT CUST_ACCOUNT_ROLE_ID from hz_cust_account_roles where party_id=l_party_id;

319: SELECT CUST_ACCOUNT_ID from hz_cust_Accounts where party_id=l_party_id;
320:
321: CURSOR GET_CONTACT_CUST_ROLE (l_party_id VARCHAR2) IS
322:
323: SELECT CUST_ACCOUNT_ROLE_ID from hz_cust_account_roles where party_id=l_party_id;
324:
325:
326: CURSOR CHECK_RELATIONSHIP_EXIST(p_person_party_id NUMBER, p_partner_party_id NUMBER) IS
327: select hzrp.party_id from hz_org_contacts hzoc, hz_relationships hzrp