238: ra_cust_trx_types.natural_application_only_flag%type,
239: p_default_tax_calculation_flag OUT NOCOPY
240: ra_cust_trx_types.tax_calculation_flag%type,
241: p_default_status_code OUT NOCOPY
242: ar_lookups.lookup_code%type,
243: p_default_status OUT NOCOPY
244: ar_lookups.meaning%type,
245: p_default_printing_option_code OUT NOCOPY
246: ar_lookups.lookup_code%type,
240: ra_cust_trx_types.tax_calculation_flag%type,
241: p_default_status_code OUT NOCOPY
242: ar_lookups.lookup_code%type,
243: p_default_status OUT NOCOPY
244: ar_lookups.meaning%type,
245: p_default_printing_option_code OUT NOCOPY
246: ar_lookups.lookup_code%type,
247: p_default_printing_option OUT NOCOPY
248: ar_lookups.meaning%type,
242: ar_lookups.lookup_code%type,
243: p_default_status OUT NOCOPY
244: ar_lookups.meaning%type,
245: p_default_printing_option_code OUT NOCOPY
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,
244: ar_lookups.meaning%type,
245: p_default_printing_option_code OUT NOCOPY
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,
309: p_default_printing_option_code,
310: p_default_printing_option,
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
310: p_default_printing_option,
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(+)