APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 3573: FROM hz_cust_accounts

3569:
3570: -- This cursor retrives the party id for a customer account id.
3571: CURSOR cust_party IS
3572: SELECT party_id
3573: FROM hz_cust_accounts
3574: WHERE cust_account_id = p_customer_account_id;
3575:
3576: -- This cursor retrived credit classification at site level
3577: CURSOR site (p_party_id NUMBER, p_account_id NUMBER, p_site_use_id NUMBER )IS

Line 3621: l_party_id hz_cust_accounts.party_id%TYPE;

3617: AND cust_account_id = -1
3618: AND site_use_id IS NULL;
3619:
3620: l_verdict NUMBER DEFAULT collect;
3621: l_party_id hz_cust_accounts.party_id%TYPE;
3622: l_parent_id hz_cust_accounts.party_id%TYPE;
3623:
3624: l_credit_classification
3625: ar_system_parameters.credit_classification1%TYPE;

Line 3622: l_parent_id hz_cust_accounts.party_id%TYPE;

3618: AND site_use_id IS NULL;
3619:
3620: l_verdict NUMBER DEFAULT collect;
3621: l_party_id hz_cust_accounts.party_id%TYPE;
3622: l_parent_id hz_cust_accounts.party_id%TYPE;
3623:
3624: l_credit_classification
3625: ar_system_parameters.credit_classification1%TYPE;
3626: