APPS.AR_CMGT_REVIEW_CONC dependencies on HZ_CUST_ACCOUNTS

Line 386: hz_cust_accounts cust

382: hcp.credit_classification cp_credit_classification
383: FROM hz_parties party,
384: hz_customer_profiles hcp,
385: ar_cmgt_check_lists checklist,
386: hz_cust_accounts cust
387: WHERE hcp.party_id = NVL(:bnd_party_id ,hcp.party_id)
388: AND party.party_id = hcp.party_id
389: AND hcp.CUST_ACCOUNT_ID = NVL(:bnd_cust_account_id ,hcp.CUST_ACCOUNT_ID)
390: AND hcp.cust_account_id <> -1

Line 502: FROM HZ_CUST_ACCOUNTS

498: IF (l_party_id IS NULL)
499: AND (l_cust_account_id IS NOT NULL) THEN
500: SELECT party_id
501: INTO l_party_id
502: FROM HZ_CUST_ACCOUNTS
503: WHERE CUST_ACCOUNT_ID = l_cust_account_id;
504: END IF;
505:
506: IF NVL(l_processing_option,'NONE') in ('PROCESS_REVIEWS','BOTH', 'REPORT_ONLY')