APPS.AR_BFB_UTILS_PVT dependencies on RA_TERMS

Line 123: from ra_terms_lines

119: due_months_forward
120: into dued,
121: duedom,
122: duemf
123: from ra_terms_lines
124: where term_id = p_payment_term_id;
125:
126: if dued is not null then
127: due_date := p_billing_date + dued;

Line 151: from ra_terms

147: BEGIN
148:
149: select billing_cycle_id
150: into bill_cycle_id
151: from ra_terms
152: where term_id = p_payment_term_id;
153:
154: if bill_cycle_id is not null then
155: RETURN 'Y';

Line 174: from ra_terms

170: BEGIN
171:
172: select billing_cycle_id
173: into bill_cycle_id
174: from ra_terms
175: where name = p_payment_term_name;
176:
177: if bill_cycle_id is not null then
178: RETURN 'Y';

Line 215: from ra_terms

211: BEGIN
212:
213: select billing_cycle_id
214: into bill_cycle_id
215: from ra_terms
216: where term_id = p_payment_term_id;
217:
218: return bill_cycle_id;
219: EXCEPTION

Line 288: ra_terms_b apt,

284: from ra_cust_trx_types tt,
285: hz_customer_profiles ap,
286: hz_customer_profiles sp,
287: hz_cust_site_uses su,
288: ra_terms_b apt,
289: ra_terms_b spt
290: where p_trx_type_id = tt.cust_trx_type_id
291: and p_org_id = tt.org_id
292: and p_bill_to_site = su.site_use_id

Line 289: ra_terms_b spt

285: hz_customer_profiles ap,
286: hz_customer_profiles sp,
287: hz_cust_site_uses su,
288: ra_terms_b apt,
289: ra_terms_b spt
290: where p_trx_type_id = tt.cust_trx_type_id
291: and p_org_id = tt.org_id
292: and p_bill_to_site = su.site_use_id
293: and p_bill_to_customer = ap.cust_account_id

Line 348: ra_terms_b sut,

344: ra_cust_trx_types tt,
345: hz_customer_profiles ap,
346: hz_customer_profiles sp,
347: hz_cust_site_uses su,
348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,
351: ra_terms_b ttt,
352: ra_terms_b invt

Line 349: ra_terms_b apt,

345: hz_customer_profiles ap,
346: hz_customer_profiles sp,
347: hz_cust_site_uses su,
348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,
351: ra_terms_b ttt,
352: ra_terms_b invt
353: where trx.request_id = p_request_id

Line 350: ra_terms_b spt,

346: hz_customer_profiles sp,
347: hz_cust_site_uses su,
348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,
351: ra_terms_b ttt,
352: ra_terms_b invt
353: where trx.request_id = p_request_id
354: and trx.previous_customer_trx_id IS NULL -- invoices only

Line 351: ra_terms_b ttt,

347: hz_cust_site_uses su,
348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,
351: ra_terms_b ttt,
352: ra_terms_b invt
353: where trx.request_id = p_request_id
354: and trx.previous_customer_trx_id IS NULL -- invoices only
355: and trx.term_id = invt.term_id

Line 352: ra_terms_b invt

348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,
351: ra_terms_b ttt,
352: ra_terms_b invt
353: where trx.request_id = p_request_id
354: and trx.previous_customer_trx_id IS NULL -- invoices only
355: and trx.term_id = invt.term_id
356: and trx.cust_trx_type_id = tt.cust_trx_type_id