APPS.AR_BFB_UTILS_PVT dependencies on RA_TERMS

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 132: from ra_terms_lines

128: due_months_forward
129: into dued,
130: duedom,
131: duemf
132: from ra_terms_lines
133: where term_id = p_payment_term_id;
134:
135: l_duedom := duedom ;
136: if dued is not null then

Line 169: from ra_terms

165: BEGIN
166:
167: select billing_cycle_id
168: into bill_cycle_id
169: from ra_terms
170: where term_id = p_payment_term_id;
171:
172: if bill_cycle_id is not null then
173: RETURN 'Y';

Line 192: from ra_terms

188: BEGIN
189:
190: select billing_cycle_id
191: into bill_cycle_id
192: from ra_terms
193: where name = p_payment_term_name;
194:
195: if bill_cycle_id is not null then
196: RETURN 'Y';

Line 273: from ra_terms

269: END IF;
270: IF (temp_billing_cycle_id_tab.EXISTS(p_payment_term_id) = FALSE) THEN
271: select billing_cycle_id
272: into bill_cycle_id
273: from ra_terms
274: where term_id = p_payment_term_id;
275:
276: temp_billing_cycle_id_tab(p_payment_term_id) := bill_cycle_id;
277: END IF;

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,