DBA Data[Home] [Help]

APPS.AR_BFB_UTILS_PVT dependencies on RA_CUST_TRX_TYPES

Line 315: from ra_cust_trx_types

311: open_rec VARCHAR2(1);
312: BEGIN
313: select nvl(accounting_affect_flag,'Y')
314: into open_rec
315: from ra_cust_trx_types
316: where cust_trx_type_id = p_cust_trx_type_id;
317:
318: return open_rec;
319: EXCEPTION

Line 352: from ra_cust_trx_types tt,

348: 'SITE', nvl(nvl(sp.standard_terms, ap.standard_terms), -95)
349: -- if bill level is not set
350: , -91)))
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,

Line 427: ra_cust_trx_types tt,

423: 'ACCOUNT', nvl(ap.standard_terms, -93),
424: 'SITE', nvl(nvl(sp.standard_terms, ap.standard_terms), -95)
425: , -91)))) new_term_id, trx.customer_trx_id
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,