APPS.ARP_STAGED_DUNNING dependencies on HZ_CUSTOMER_PROFILES

Line 595: FROM hz_customer_profiles cust_cp

591: ,nvl(site_cpa.min_dunning_invoice_amount,
592: nvl(cust_cpa.min_dunning_invoice_amount, 0 ))
593: INTO min_dun_amount
594: ,min_dun_inv_amount
595: FROM hz_customer_profiles cust_cp
596: ,hz_cust_profile_amts cust_cpa
597: ,hz_customer_profiles site_cp
598: ,hz_cust_profile_amts site_cpa
599: where CUST_CP.CUST_ACCOUNT_ID = site.customer_id

Line 597: ,hz_customer_profiles site_cp

593: INTO min_dun_amount
594: ,min_dun_inv_amount
595: FROM hz_customer_profiles cust_cp
596: ,hz_cust_profile_amts cust_cpa
597: ,hz_customer_profiles site_cp
598: ,hz_cust_profile_amts site_cpa
599: where CUST_CP.CUST_ACCOUNT_ID = site.customer_id
600: AND cust_cp.site_use_id IS NULL
601: AND cust_cpa.cust_account_profile_id(+)= cust_cp.cust_account_profile_id

Line 616: FROM hz_customer_profiles cust_cp

612: SELECT nvl(cust_cpa.min_dunning_amount, 0)
613: ,nvl(cust_cpa.min_dunning_invoice_amount, 0)
614: INTO min_dun_amount
615: ,min_dun_inv_amount
616: FROM hz_customer_profiles cust_cp
617: ,hz_cust_profile_amts cust_cpa
618: WHERE cust_cp.cust_account_id = site.customer_id
619: AND cust_cp.site_use_id IS NULL
620: AND cust_cpa.cust_account_profile_id(+)

Line 631: FROM hz_customer_profiles

627: min_dun_inv_amount
628: FROM hz_cust_profile_amts
629: WHERE CUST_ACCOUNT_PROFILE_ID =
630: (SELECT cust_account_profile_id
631: FROM hz_customer_profiles
632: WHERE site_use_id = arpt_sql_func_util.get_bill_id(site.site_use_id))
633: AND currency_code = curr_code
634: AND CUST_ACCOUNT_ID = site.customer_id;
635: end if;