APPS.AR_BFB_UTILS_PVT dependencies on RA_CUST_TRX_TYPES

Line 247: from ra_cust_trx_types

243: open_rec VARCHAR2(1);
244: BEGIN
245: select nvl(accounting_affect_flag,'Y')
246: into open_rec
247: from ra_cust_trx_types
248: where cust_trx_type_id = p_cust_trx_type_id;
249:
250: return open_rec;
251: EXCEPTION

Line 284: from ra_cust_trx_types tt,

280: 'SITE', nvl(nvl(sp.standard_terms, ap.standard_terms), -95)
281: -- if bill level is not set
282: , -91)))
283: into l_default_term
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,

Line 344: ra_cust_trx_types tt,

340: 'ACCOUNT', nvl(ap.standard_terms, -93),
341: 'SITE', nvl(nvl(sp.standard_terms, ap.standard_terms), -95)
342: , -91)))) new_term_id, trx.customer_trx_id
343: from ra_customer_trx trx,
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,