[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT lookup_code,
meaning
INTO p_default_status_code,
p_default_status
FROM ar_lookups arl_status
WHERE 'INVOICE_TRX_STATUS' = arl_status.lookup_type
AND 'OP' = arl_status.lookup_code
AND 'Y' = arl_status.enabled_flag
AND NVL(p_trx_date, TRUNC(SYSDATE))
BETWEEN arl_status.start_date_active
AND NVL(arl_status.end_date_active,
NVL( p_trx_date, TRUNC(SYSDATE) ) );
SELECT lookup_code,
meaning
INTO p_default_printing_option_code,
p_default_printing_option
FROM ar_lookups arl_print
WHERE 'INVOICE_PRINT_OPTIONS' = arl_print.lookup_type
AND 'PRI' = arl_print.lookup_code
AND 'Y' = arl_print.enabled_flag
AND NVL(p_trx_date, TRUNC(SYSDATE))
BETWEEN arl_print.start_date_active
AND NVL(arl_print.end_date_active,
NVL( p_trx_date, TRUNC(SYSDATE) ) );
SELECT NVL(s.name, s1.name),
NVL(s.salesrep_number, s1.salesrep_number),
NVL(s.salesrep_id, s1.salesrep_id)
INTO p_primary_salesrep_name,
p_primary_salesrep_number,
p_primary_salesrep_id
FROM ra_salesreps s,
ra_salesreps s1,
hz_cust_accounts cust_acct
WHERE cust_acct.primary_salesrep_id = s.salesrep_id(+)
AND cust_acct.cust_account_id = p_customer_id
AND DECODE(p_salesrep_required_flag,
'Y', -3,
-100) = s1.salesrep_id(+)
AND p_trx_date BETWEEN
NVL(s.start_date_active(+), p_trx_date) AND
NVL(s.end_date_active(+), p_trx_date)
AND p_trx_date BETWEEN
NVL(s1.start_date_active(+), p_trx_date) AND
NVL(s1.end_date_active(+), p_trx_date);