APPS.PV_CONTACT_USER_BATCH_PUB dependencies on HZ_CUST_ACCOUNTS

Line 319: SELECT CUST_ACCOUNT_ID from hz_cust_Accounts where party_id=l_party_id;

315: AND EFFECTIVE_START_DATE < SYSDATE;
316:
317: CURSOR GET_PARTNER_CUST_ACCT (l_party_id VARCHAR2) IS
318:
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;