APPS.AR_BFB_UTILS_PVT dependencies on RA_TERMS_B

Line 14: TYPE billing_cycle_id_cach is table of ra_terms.billing_cycle_id%type

10: INDEX BY BINARY_INTEGER;
11:
12: temp_bill_level_table hz_customer_prof_cach;
13:
14: TYPE billing_cycle_id_cach is table of ra_terms.billing_cycle_id%type
15: INDEX BY BINARY_INTEGER;
16: temp_billing_cycle_id_tab billing_cycle_id_cach;
17:
18: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line 355: ra_terms_b apt,

351: into l_default_term
352: from ra_cust_trx_types tt,
353: hz_customer_profiles ap,
354: hz_cust_site_uses su,
355: ra_terms_b apt,
356: ra_terms_b spt,
357: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
358: su2.site_use_id profile_bill_to_site_use_id
359: from hz_customer_profiles cp,

Line 356: ra_terms_b spt,

352: from ra_cust_trx_types tt,
353: hz_customer_profiles ap,
354: hz_cust_site_uses su,
355: ra_terms_b apt,
356: ra_terms_b spt,
357: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
358: su2.site_use_id profile_bill_to_site_use_id
359: from hz_customer_profiles cp,
360: hz_cust_site_uses su1,

Line 430: ra_terms_b sut,

426: from ra_customer_trx trx,
427: ra_cust_trx_types tt,
428: hz_customer_profiles ap,
429: hz_cust_site_uses su,
430: ra_terms_b sut,
431: ra_terms_b apt,
432: ra_terms_b spt,
433: ra_terms_b ttt,
434: ra_terms_b invt,

Line 431: ra_terms_b apt,

427: ra_cust_trx_types tt,
428: hz_customer_profiles ap,
429: hz_cust_site_uses su,
430: ra_terms_b sut,
431: ra_terms_b apt,
432: ra_terms_b spt,
433: ra_terms_b ttt,
434: ra_terms_b invt,
435: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,

Line 432: ra_terms_b spt,

428: hz_customer_profiles ap,
429: hz_cust_site_uses su,
430: ra_terms_b sut,
431: ra_terms_b apt,
432: ra_terms_b spt,
433: ra_terms_b ttt,
434: ra_terms_b invt,
435: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
436: su2.site_use_id profile_bill_to_site_use_id

Line 433: ra_terms_b ttt,

429: hz_cust_site_uses su,
430: ra_terms_b sut,
431: ra_terms_b apt,
432: ra_terms_b spt,
433: ra_terms_b ttt,
434: ra_terms_b invt,
435: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
436: su2.site_use_id profile_bill_to_site_use_id
437: from hz_customer_profiles cp,

Line 434: ra_terms_b invt,

430: ra_terms_b sut,
431: ra_terms_b apt,
432: ra_terms_b spt,
433: ra_terms_b ttt,
434: ra_terms_b invt,
435: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
436: su2.site_use_id profile_bill_to_site_use_id
437: from hz_customer_profiles cp,
438: hz_cust_site_uses su1,