[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select decode(p_currency_code,
NULL , NULL , nvl(sum(a.amount),0)),
nvl(sum( decode(p_exc_rate,
NULL, a.acctd_amount,
arpcurr.functional_amount(a.amount,
p_func_curr,
p_exc_rate,
p_precision,
p_min_acc_unit ))),0),
count(a.amount)
into p_financecharg_amount,
p_financecharg_func_amt,
p_financecharg_count
from ar_adjustments a,
ar_payment_schedules ps,
ar_receivables_trx rt
where
a.gl_date between p_start_date
and p_end_date
and nvl(a.postable,'Y') = 'Y'
and a.payment_schedule_id = ps.payment_schedule_id
and ps.customer_id = p_customer_id
and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
and a.receivables_trx_id = rt.receivables_trx_id
and nvl(rt.type,'X') = 'FINCHRG'
AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y';
SELECT decode(p_currency_code,
NULL , NULL , nvl(sum(ra.earned_discount_taken),0)),
decode(p_currency_code,
NULL , NULL , nvl(sum(ra.unearned_discount_taken),0)),
nvl(sum( decode(p_exc_rate,
NULL, ra.acctd_earned_discount_taken,
arpcurr.functional_amount( nvl(ra.earned_discount_taken,0),
p_func_curr,
p_exc_rate,
p_precision,
p_min_acc_unit ))),0),
nvl(sum( decode(p_exc_rate,
NULL, ra.acctd_unearned_discount_taken,
arpcurr.functional_amount( nvl(ra.unearned_discount_taken,0),
p_func_curr,
p_exc_rate,
p_precision,
p_min_acc_unit ))),0),
count(ra.earned_discount_taken),
count(ra.unearned_discount_taken)
INTO p_earned_discounts,
p_unearned_discounts,
p_earned_func_disc,
p_unearned_func_disc,
p_earned_disc_count,
p_unearned_disc_count
FROM ar_payment_schedules ps,
ar_receivable_applications ra
where
ra.gl_date between p_start_date
and p_end_date
AND ps.payment_schedule_id = ra.applied_payment_schedule_id
and ps.customer_id = p_customer_id
and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y';