APPS.AR_RECEIPT_LIB_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 535: hz_customer_profiles cp,

531: /* fixed bug 1544201: removed customer_prospect_code */
532: SELECT c.cust_account_id
533: INTO l_selected_id
534: FROM hz_cust_accounts c,
535: hz_customer_profiles cp,
536: hz_parties party
537: WHERE c.cust_account_id = cp.cust_account_id (+) and
538: cp.site_use_id is null and
539: c.account_number = p_value

Line 550: hz_customer_profiles cp,

546: /* fixed bug 1544201: removed customer_prospect_code */
547: SELECT cust_acct.cust_account_id
548: INTO l_selected_id
549: FROM hz_cust_accounts cust_acct,
550: hz_customer_profiles cp,
551: hz_parties party
552: WHERE cust_acct.cust_account_id = cp.cust_account_id (+)
553: and cust_acct.party_id = party.party_id(+)
554: and cp.site_use_id is null

Line 2360: hz_customer_profiles cust,

2356: /* modified for tca uptake */
2357: SELECT NVL(NVL(site.discount_grace_days, cust.discount_grace_days),0)
2358: INTO l_grace_days
2359: FROM
2360: hz_customer_profiles cust,
2361: hz_customer_profiles site,
2362: hz_cust_accounts c
2363: WHERE
2364: c.cust_account_id = p_customer_id

Line 2361: hz_customer_profiles site,

2357: SELECT NVL(NVL(site.discount_grace_days, cust.discount_grace_days),0)
2358: INTO l_grace_days
2359: FROM
2360: hz_customer_profiles cust,
2361: hz_customer_profiles site,
2362: hz_cust_accounts c
2363: WHERE
2364: c.cust_account_id = p_customer_id
2365: AND cust.cust_account_id = c.cust_account_id

Line 3217: hz_customer_profiles cust

3213: See if discounts are allowed for this customer */
3214: SELECT NVL(NVL(site.discount_terms, cust.discount_terms),'Y')
3215: INTO l_allow_discount
3216: FROM
3217: hz_customer_profiles cust
3218: , hz_customer_profiles site
3219: WHERE
3220: cust.cust_account_id = p_customer_id
3221: AND cust.site_use_id IS NULL

Line 3218: , hz_customer_profiles site

3214: SELECT NVL(NVL(site.discount_terms, cust.discount_terms),'Y')
3215: INTO l_allow_discount
3216: FROM
3217: hz_customer_profiles cust
3218: , hz_customer_profiles site
3219: WHERE
3220: cust.cust_account_id = p_customer_id
3221: AND cust.site_use_id IS NULL
3222: AND site.cust_account_id (+) = cust.cust_account_id