APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 1619: hz_customer_profiles hcp,

1615: NVL(ctl.ship_to_site_use_id,ct.ship_to_site_use_id)
1616: FROM
1617: ra_customer_trx ct,
1618: ra_customer_trx_lines ctl,
1619: hz_customer_profiles hcp,
1620: ra_cust_trx_types ctt
1621: WHERE (ctl.customer_trx_line_id = p_customer_trx_line_id)
1622: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1623: AND ctt.type = 'INV'

Line 1669: hz_customer_profiles hcp,

1665: NVL(ctl.ship_to_site_use_id,ct.ship_to_site_use_id)
1666: FROM
1667: ra_customer_trx ct,
1668: ra_customer_trx_lines ctl,
1669: hz_customer_profiles hcp,
1670: ra_cust_trx_types ctt
1671: WHERE ct.request_id = p_request_id
1672: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1673: AND ctt.type = 'INV'

Line 3579: FROM hz_customer_profiles

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
3578: SELECT credit_classification
3579: FROM hz_customer_profiles
3580: WHERE party_id = p_party_id
3581: AND cust_account_id = p_account_id
3582: AND site_use_id = p_site_use_id;
3583:

Line 3587: FROM hz_customer_profiles

3583:
3584: -- This cursor retrives credit classification at account level
3585: CURSOR account (p_party_id NUMBER, p_account_id NUMBER )IS
3586: SELECT credit_classification
3587: FROM hz_customer_profiles
3588: WHERE party_id = p_party_id
3589: AND cust_account_id = p_account_id
3590: AND site_use_id IS NULL;
3591:

Line 3595: FROM hz_customer_profiles

3591:
3592: -- This cursor retrives credit classification at party level
3593: CURSOR party (p_party_id NUMBER) IS
3594: SELECT credit_classification
3595: FROM hz_customer_profiles
3596: WHERE party_id = p_party_id
3597: AND cust_account_id = -1;
3598:
3599: -- This cursor traverses the party hierarchy.

Line 3615: FROM hz_customer_profiles

3611: -- This cursor retrieves credit classifiction for parties
3612: -- in party hierarchy.
3613: CURSOR parent (p_party_id NUMBER) IS
3614: SELECT credit_classification
3615: FROM hz_customer_profiles
3616: WHERE party_id = p_party_id
3617: AND cust_account_id = -1
3618: AND site_use_id IS NULL;
3619: