APPS.ARP_BF_BILL dependencies on HZ_CUSTOMER_PROFILES

Line 617: hz_customer_profiles cp1,

613: cp2.standard_terms acct_term
614: FROM hz_cust_accounts acct,
615: hz_cust_acct_sites acct_site,
616: hz_cust_site_uses site_uses,
617: hz_customer_profiles cp1,
618: hz_customer_profiles cp2
619: WHERE acct.account_number between P_cust_num_low and P_cust_num_high
620: AND acct_site.cust_account_id = acct.cust_account_id
621: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

Line 618: hz_customer_profiles cp2

614: FROM hz_cust_accounts acct,
615: hz_cust_acct_sites acct_site,
616: hz_cust_site_uses site_uses,
617: hz_customer_profiles cp1,
618: hz_customer_profiles cp2
619: WHERE acct.account_number between P_cust_num_low and P_cust_num_high
620: AND acct_site.cust_account_id = acct.cust_account_id
621: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
622: AND site_uses.site_use_id between P_bill_site_low and P_bill_site_high

Line 707: cons_inv_type hz_customer_profiles.cons_inv_type%TYPE );

703: ( customer_id NUMBER,
704: site_id NUMBER,
705: bill_level VARCHAR2(1),
706: override_terms VARCHAR2(1),
707: cons_inv_type hz_customer_profiles.cons_inv_type%TYPE );
708:
709: L_sites L_sites_type ;
710:
711: /* Bug 5203710 remove detail_option as limiting criteria */

Line 712: --C_detail_option hz_customer_profiles.cons_inv_type%TYPE;

708:
709: L_sites L_sites_type ;
710:
711: /* Bug 5203710 remove detail_option as limiting criteria */
712: --C_detail_option hz_customer_profiles.cons_inv_type%TYPE;
713:
714: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;
715: TYPE tab_num IS TABLE OF NUMBER ;
716:

Line 883: -- pick up BFB related data from hz_customer_profiles

879: IF l_billing_date > sysdate then
880: write_debug_and_log('...BYPASSING THIS CYCLE SINCE NEXT SCHEDULED BILLING DATE IS IN THE FUTURE');
881: ELSE
882:
883: -- pick up BFB related data from hz_customer_profiles
884: -- if bill_level = 'SITE', get term from site level profile
885: -- = 'ACCOUNT', get term from account level profile
886:
887: -- pre-process the parameter ranges passed in

Line 945: 'hz_customer_profiles CP, ' ||

941: c_site_from :=
942: 'FROM ' ||
943: 'hz_cust_acct_sites acct_site, ' ||
944: 'hz_cust_site_uses site_uses, ' ||
945: 'hz_customer_profiles CP, ' ||
946: 'hz_customer_profiles SP ';
947:
948: -- define generic WHERE clause
949: /* Bug 5203710 remove cons_inv_type as limiting criteria */

Line 946: 'hz_customer_profiles SP ';

942: 'FROM ' ||
943: 'hz_cust_acct_sites acct_site, ' ||
944: 'hz_cust_site_uses site_uses, ' ||
945: 'hz_customer_profiles CP, ' ||
946: 'hz_customer_profiles SP ';
947:
948: -- define generic WHERE clause
949: /* Bug 5203710 remove cons_inv_type as limiting criteria */
950: c_site_where :=