APPS.ARP_TRX_DEFAULTS_2 dependencies on RA_TERMS

Line 250: ra_terms.term_id%type,

246: ar_lookups.lookup_code%type,
247: p_default_printing_option OUT NOCOPY
248: ar_lookups.meaning%type,
249: p_default_term_id OUT NOCOPY
250: ra_terms.term_id%type,
251: p_default_term_name OUT NOCOPY
252: ra_terms.name%type,
253: p_number_of_due_dates OUT NOCOPY number,
254: p_term_due_date OUT NOCOPY

Line 252: ra_terms.name%type,

248: ar_lookups.meaning%type,
249: p_default_term_id OUT NOCOPY
250: ra_terms.term_id%type,
251: p_default_term_name OUT NOCOPY
252: ra_terms.name%type,
253: p_number_of_due_dates OUT NOCOPY number,
254: p_term_due_date OUT NOCOPY
255: ra_customer_trx.term_due_date%type,
256: p_security_inv_enter_flag IN

Line 267: l_default_term_id ra_terms.term_id%type;

263: varchar2 DEFAULT 'Y'
264: ) IS
265:
266: l_number_of_due_dates number;
267: l_default_term_id ra_terms.term_id%type;
268: l_term_due_date ra_customer_trx.term_due_date%type;
269:
270: BEGIN
271:

Line 315: ra_terms rat,

311: l_default_term_id,
312: p_default_term_name
313: FROM ar_lookups arl_print,
314: ar_lookups arl_status,
315: ra_terms rat,
316: ra_cust_trx_types ctt
317: WHERE ctt.cust_trx_type_id = p_cust_trx_type_id
318: AND 'INVOICE_PRINT_OPTIONS' = arl_print.lookup_type(+)
319: AND ctt.default_printing_option = arl_print.lookup_code(+)

Line 454: FROM ra_terms_lines

450: arpt_sql_func_util.get_First_Due_Date(l_default_term_id,
451: p_trx_date)
452: INTO l_number_of_due_dates,
453: l_term_due_date
454: FROM ra_terms_lines
455: WHERE term_id = l_default_term_id;
456:
457: -- Guarantees cannot have split term terms
458: