APPS.AR_RECEIPT_LIB_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 536: hz_customer_profiles cp,

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

Line 551: hz_customer_profiles cp,

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

Line 2367: hz_customer_profiles cust,

2363: /* modified for tca uptake */
2364: SELECT NVL(NVL(site.discount_grace_days, cust.discount_grace_days),0)
2365: INTO l_grace_days
2366: FROM
2367: hz_customer_profiles cust,
2368: hz_customer_profiles site,
2369: hz_cust_accounts c
2370: WHERE
2371: c.cust_account_id = p_customer_id

Line 2368: hz_customer_profiles site,

2364: SELECT NVL(NVL(site.discount_grace_days, cust.discount_grace_days),0)
2365: INTO l_grace_days
2366: FROM
2367: hz_customer_profiles cust,
2368: hz_customer_profiles site,
2369: hz_cust_accounts c
2370: WHERE
2371: c.cust_account_id = p_customer_id
2372: AND cust.cust_account_id = c.cust_account_id

Line 3399: hz_customer_profiles cust

3395: See if discounts are allowed for this customer */
3396: SELECT NVL(NVL(site.discount_terms, cust.discount_terms),'Y')
3397: INTO l_allow_discount
3398: FROM
3399: hz_customer_profiles cust
3400: , hz_customer_profiles site
3401: WHERE
3402: cust.cust_account_id = p_customer_id
3403: AND cust.site_use_id IS NULL

Line 3400: , hz_customer_profiles site

3396: SELECT NVL(NVL(site.discount_terms, cust.discount_terms),'Y')
3397: INTO l_allow_discount
3398: FROM
3399: hz_customer_profiles cust
3400: , hz_customer_profiles site
3401: WHERE
3402: cust.cust_account_id = p_customer_id
3403: AND cust.site_use_id IS NULL
3404: AND site.cust_account_id (+) = cust.cust_account_id