APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 1534: hz_customer_profiles hcp,

1530: NVL(ctl.ship_to_site_use_id,ct.ship_to_site_use_id)
1531: FROM
1532: ra_customer_trx ct,
1533: ra_customer_trx_lines ctl,
1534: hz_customer_profiles hcp,
1535: ra_cust_trx_types ctt
1536: WHERE (ctl.customer_trx_line_id = p_customer_trx_line_id)
1537: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1538: AND ctt.type = 'INV'

Line 1583: hz_customer_profiles hcp,

1579: NVL(ctl.ship_to_site_use_id,ct.ship_to_site_use_id)
1580: FROM
1581: ra_customer_trx ct,
1582: ra_customer_trx_lines ctl,
1583: hz_customer_profiles hcp,
1584: ra_cust_trx_types ctt
1585: WHERE ct.request_id = p_request_id
1586: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1587: AND ctt.type = 'INV'

Line 3439: FROM hz_customer_profiles

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
3438: SELECT credit_classification
3439: FROM hz_customer_profiles
3440: WHERE party_id = p_party_id
3441: AND cust_account_id = p_account_id
3442: AND site_use_id = p_site_use_id;
3443:

Line 3447: FROM hz_customer_profiles

3443:
3444: -- This cursor retrives credit classification at account level
3445: CURSOR account (p_party_id NUMBER, p_account_id NUMBER )IS
3446: SELECT credit_classification
3447: FROM hz_customer_profiles
3448: WHERE party_id = p_party_id
3449: AND cust_account_id = p_account_id
3450: AND rownum = 1;
3451:

Line 3455: FROM hz_customer_profiles

3451:
3452: -- This cursor retrives credit classification at party level
3453: CURSOR party (p_party_id NUMBER) IS
3454: SELECT credit_classification
3455: FROM hz_customer_profiles
3456: WHERE party_id = p_party_id
3457: AND rownum = 1;
3458:
3459: -- This cursor traverses the party hierarchy.

Line 3475: FROM hz_customer_profiles

3471: -- This cursor retrieves credit classifiction for parties
3472: -- in party hierarchy.
3473: CURSOR parent (p_party_id NUMBER) IS
3474: SELECT credit_classification
3475: FROM hz_customer_profiles
3476: WHERE party_id = p_party_id
3477: AND cust_account_id = -1
3478: AND site_use_id IS NULL;
3479: