APPS.ARP_BF_BILL dependencies on HZ_CUSTOMER_PROFILES

Line 598: hz_customer_profiles cp1,

594: cp2.standard_terms acct_term
595: FROM hz_cust_accounts acct,
596: hz_cust_acct_sites acct_site,
597: hz_cust_site_uses site_uses,
598: hz_customer_profiles cp1,
599: hz_customer_profiles cp2
600: WHERE acct.account_number between P_cust_num_low and P_cust_num_high
601: AND acct_site.cust_account_id = acct.cust_account_id
602: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

Line 599: hz_customer_profiles cp2

595: FROM hz_cust_accounts acct,
596: hz_cust_acct_sites acct_site,
597: hz_cust_site_uses site_uses,
598: hz_customer_profiles cp1,
599: hz_customer_profiles cp2
600: WHERE acct.account_number between P_cust_num_low and P_cust_num_high
601: AND acct_site.cust_account_id = acct.cust_account_id
602: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
603: AND site_uses.site_use_id between P_bill_site_low and P_bill_site_high

Line 688: cons_inv_type hz_customer_profiles.cons_inv_type%TYPE );

684: ( customer_id NUMBER,
685: site_id NUMBER,
686: bill_level VARCHAR2(1),
687: override_terms VARCHAR2(1),
688: cons_inv_type hz_customer_profiles.cons_inv_type%TYPE );
689:
690: L_sites L_sites_type ;
691:
692: /* Bug 5203710 remove detail_option as limiting criteria */

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

689:
690: L_sites L_sites_type ;
691:
692: /* Bug 5203710 remove detail_option as limiting criteria */
693: --C_detail_option hz_customer_profiles.cons_inv_type%TYPE;
694:
695: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;
696: TYPE tab_num IS TABLE OF NUMBER ;
697:

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

861: IF l_billing_date > sysdate and nvl(p_future_date_bill_flag, 'N') = 'N' then --Bug 12739341, add a flag to check whether it can generate future date bill
862: write_debug_and_log('...BYPASSING THIS CYCLE SINCE NEXT SCHEDULED BILLING DATE IS IN THE FUTURE');
863: ELSE
864:
865: -- pick up BFB related data from hz_customer_profiles
866: -- if bill_level = 'SITE', get term from site level profile
867: -- = 'ACCOUNT', get term from account level profile
868:
869: -- pre-process the parameter ranges passed in

Line 927: 'hz_customer_profiles CP, ' ||

923: c_site_from :=
924: 'FROM ' ||
925: 'hz_cust_acct_sites acct_site, ' ||
926: 'hz_cust_site_uses site_uses, ' ||
927: 'hz_customer_profiles CP, ' ||
928: 'hz_customer_profiles SP ';
929:
930: -- define generic WHERE clause
931: /* Bug 5203710 remove cons_inv_type as limiting criteria */

Line 928: 'hz_customer_profiles SP ';

924: 'FROM ' ||
925: 'hz_cust_acct_sites acct_site, ' ||
926: 'hz_cust_site_uses site_uses, ' ||
927: 'hz_customer_profiles CP, ' ||
928: 'hz_customer_profiles SP ';
929:
930: -- define generic WHERE clause
931: /* Bug 5203710 remove cons_inv_type as limiting criteria */
932: c_site_where :=