APPS.OE_CREDIT_CHECK_RPT dependencies on HZ_CUST_PROFILE_AMTS

Line 1803: , hz_cust_profile_amts cpa

1799: cpa.currency_code party_currency_code
1800: , cpa.overall_credit_limit party_overall_limit
1801: FROM
1802: hz_customer_profiles cp
1803: , hz_cust_profile_amts cpa
1804: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
1805: AND cp.site_use_id IS NULL
1806: AND cp.cust_account_id=-1
1807: AND cp.party_id=p_party_id;

Line 1857: , hz_cust_profile_amts cpa

1853: cpa.currency_code cust_currency_code
1854: , cpa.overall_credit_limit cust_overall_limit
1855: FROM
1856: hz_customer_profiles cp
1857: , hz_cust_profile_amts cpa
1858: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
1859: AND cp.site_use_id IS NULL
1860: AND cp.cust_account_id=p_customer_id;
1861:

Line 1887: , hz_cust_profile_amts cpa

1883: cpa.currency_code site_currency_code
1884: , cpa.overall_credit_limit site_overall_limit
1885: FROM
1886: hz_customer_profiles cp
1887: , hz_cust_profile_amts cpa
1888: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
1889: AND cp.site_use_id =p_site_id
1890: AND cp.cust_account_id=p_customer_id;
1891:

Line 2228: , hz_cust_profile_amts cpa

2224: SELECT COUNT(*)
2225: INTO l_prof_count
2226: FROM
2227: hz_customer_profiles cp
2228: , hz_cust_profile_amts cpa
2229: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
2230: AND cp.site_use_id IS NULL
2231: AND cp.cust_account_id=-1
2232: AND cp.party_id=party_csr_rec.party_id;

Line 2567: , hz_cust_profile_amts cpa

2563: SELECT COUNT(*)
2564: INTO l_prof_count
2565: FROM
2566: hz_customer_profiles cp
2567: , hz_cust_profile_amts cpa
2568: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
2569: AND cp.site_use_id IS NULL
2570: AND cp.cust_account_id=-1
2571: AND cp.party_id=party_hier_csr_rec.party_id;

Line 2864: , hz_cust_profile_amts cpa

2860: SELECT COUNT(*)
2861: INTO l_prof_count
2862: FROM
2863: hz_customer_profiles cp
2864: , hz_cust_profile_amts cpa
2865: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
2866: AND cp.site_use_id IS NULL
2867: AND cp.cust_account_id=party_cust_csr_rec.customer_id;
2868:

Line 3168: , hz_cust_profile_amts cpa

3164: SELECT COUNT(*)
3165: INTO l_prof_count
3166: FROM
3167: hz_customer_profiles cp
3168: , hz_cust_profile_amts cpa
3169: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
3170: AND cp.site_use_id IS NULL
3171: AND cp.cust_account_id=-1
3172: AND cp.party_id=party_hier_csr1_rec.party_id;

Line 3465: , hz_cust_profile_amts cpa

3461: SELECT COUNT(*)
3462: INTO l_prof_count
3463: FROM
3464: hz_customer_profiles cp
3465: , hz_cust_profile_amts cpa
3466: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
3467: AND cp.site_use_id IS NULL
3468: AND cp.cust_account_id=party_cust_csr_rec.customer_id;
3469:

Line 3966: , hz_cust_profile_amts cpa

3962: SELECT COUNT(*)
3963: INTO l_prof_count
3964: FROM
3965: hz_customer_profiles cp
3966: , hz_cust_profile_amts cpa
3967: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
3968: AND cp.site_use_id IS NULL
3969: AND cp.cust_account_id=cust_csr_rec.customer_id;
3970:

Line 4246: , hz_cust_profile_amts cpa

4242: SELECT COUNT(*)
4243: INTO l_prof_count1
4244: FROM
4245: hz_customer_profiles cp
4246: , hz_cust_profile_amts cpa
4247: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
4248: AND cp.site_use_id =site_csr_rec.site_id
4249: AND cp.cust_account_id=cust_csr_rec.customer_id;
4250: