APPS.HZ_CREDIT_USAGES_PKG dependencies on HZ_CUST_PROFILE_AMTS

Line 305: , hz_cust_profile_amts cpa

301: trx_limit
302: , cp.credit_checking
303: , cu.credit_usage_rule_set_id
304: FROM hz_customer_profiles cp
305: , hz_cust_profile_amts cpa
306: , hz_credit_usages cu
307: , hz_credit_usage_rules cur
308: WHERE cp.cust_account_id = p_entity_id
309: AND cp.site_use_id IS NULL

Line 334: , hz_cust_profile_amts cpa

330: trx_limit
331: , cp.credit_checking
332: , cu.credit_usage_rule_set_id
333: FROM hz_customer_profiles cp
334: , hz_cust_profile_amts cpa
335: , hz_credit_usages cu
336: , hz_credit_usage_rules cur
337: WHERE cp.cust_account_id = p_entity_id
338: AND cp.site_use_id IS NULL

Line 370: , hz_cust_profile_amts cpa

366: trx_limit
367: , cp.credit_checking
368: , cu.credit_usage_rule_set_id
369: FROM hz_customer_profiles cp
370: , hz_cust_profile_amts cpa
371: , hz_credit_usages cu
372: , hz_credit_usage_rules cur
373: WHERE cp.site_use_id = p_entity_id
374: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 397: , hz_cust_profile_amts cpa

393: trx_limit
394: , cp.credit_checking
395: , cu.credit_usage_rule_set_id
396: FROM hz_customer_profiles cp
397: , hz_cust_profile_amts cpa
398: , hz_credit_usages cu
399: , hz_credit_usage_rules cur
400: WHERE cp.site_use_id = p_entity_id
401: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 430: , hz_cust_profile_amts cpa

426: trx_limit
427: , cp.credit_checking
428: , cu.credit_usage_rule_set_id
429: FROM hz_customer_profiles cp
430: , hz_cust_profile_amts cpa
431: , hz_credit_usages cu
432: , hz_credit_usage_rules cur
433: WHERE cp.cust_account_id = -1
434: AND cp.site_use_id IS NULL

Line 460: , hz_cust_profile_amts cpa

456: trx_limit
457: , cp.credit_checking
458: , cu.credit_usage_rule_set_id
459: FROM hz_customer_profiles cp
460: , hz_cust_profile_amts cpa
461: , hz_credit_usages cu
462: , hz_credit_usage_rules cur
463: WHERE cp.cust_account_id = -1
464: AND cp.site_use_id IS NULL