APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 3433: FROM hz_cust_accounts

3429:
3430: -- This cursor retrives the party id for a customer account id.
3431: CURSOR cust_party IS
3432: SELECT party_id
3433: FROM hz_cust_accounts
3434: WHERE cust_account_id = p_customer_account_id;
3435:
3436: -- This cursor retrived credit classification at site level
3437: CURSOR site (p_party_id NUMBER, p_account_id NUMBER, p_site_use_id NUMBER )IS

Line 3481: l_party_id hz_cust_accounts.party_id%TYPE;

3477: AND cust_account_id = -1
3478: AND site_use_id IS NULL;
3479:
3480: l_verdict NUMBER DEFAULT collect;
3481: l_party_id hz_cust_accounts.party_id%TYPE;
3482: l_parent_id hz_cust_accounts.party_id%TYPE;
3483:
3484: l_credit_classification
3485: ar_system_parameters.credit_classification1%TYPE;

Line 3482: l_parent_id hz_cust_accounts.party_id%TYPE;

3478: AND site_use_id IS NULL;
3479:
3480: l_verdict NUMBER DEFAULT collect;
3481: l_party_id hz_cust_accounts.party_id%TYPE;
3482: l_parent_id hz_cust_accounts.party_id%TYPE;
3483:
3484: l_credit_classification
3485: ar_system_parameters.credit_classification1%TYPE;
3486: