[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT dist.code_combination_id ccid
FROM ar_distributions dist,
ar_cash_receipt_history crh
WHERE dist.source_table = 'CRH'
AND dist.source_id = crh.cash_receipt_history_id
AND dist.source_type = P_source_type
AND crh.cash_receipt_id = P_cr_id
ORDER BY LINE_ID desc;
SELECT rc.creation_status,
decode( rc.creation_status,
'APPROVED', null,
'CONFIRMED','CONFIRMATION',
'REMITTED', 'REMITTANCE',
'CLEARED', 'CASH' ),
decode(rc.creation_status,
'APPROVED',null,
'CONFIRMED', rma.receipt_clearing_ccid,
'REMITTED', rma.remittance_ccid,
'CLEARED', rma.cash_ccid),
nvl(rma.override_remit_account_flag,'Y')
INTO l_history_status,
l_source_type,
l_ccid,
l_override_remit_account_flag
FROM ar_receipt_classes rc,
ar_receipt_methods rm,
ar_receipt_method_accounts rma
WHERE rm.receipt_class_id = rc.receipt_class_id
AND rm.receipt_method_id = p_receipt_method_id
AND rma.receipt_method_id = rm.receipt_method_id
AND rma.remit_bank_acct_use_id = P_remit_bank_account_id;
SELECT max(crh.batch_id)
INTO p_batch_id
FROM ar_cash_receipt_history crh,
ar_batches bat
WHERE crh.cash_receipt_id = p_cr_id
AND crh.first_posted_record_flag = 'Y'
AND bat.batch_id = crh.batch_id
AND bat.type = 'MANUAL';