APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_RCV_RTV_BATCH_TRXS

Line 2130: from JAI_RCV_TRANSACTIONS a, jai_rcv_rtv_batch_trxs b

2126: nvl(b.receipt_excise_rate,0) receipt_excise_rate,
2127: nvl(b.rtv_excise_rate, nvl(b.receipt_excise_rate, 0)) rtv_excise_rate,
2128: decode( b.excise_batch_num, cpn_batch_num, jai_constants.yes, jai_constants.no) process_excise_in_batch,
2129: decode( b.vat_batch_num, cpn_batch_num, jai_constants.yes, jai_constants.no) process_vat_in_batch
2130: from JAI_RCV_TRANSACTIONS a, jai_rcv_rtv_batch_trxs b
2131: where a.transaction_id = b.transaction_id
2132: and (pn_min_transaction_id is null or a.transaction_id >= pn_min_transaction_id)
2133: and (pn_max_transaction_id is null or a.transaction_id <= pn_max_transaction_id)
2134: and

Line 2471: update jai_rcv_rtv_batch_trxs

2467:
2468: if rtv_rec.process_excise_in_batch = jai_constants.yes
2469: or rtv_rec.process_vat_in_batch = jai_constants.yes
2470: then
2471: update jai_rcv_rtv_batch_trxs
2472: set excise_batch_group_id = decode(rtv_rec.process_excise_in_batch, jai_constants.yes, ln_excise_batch_group_id),
2473: vat_batch_group_id = decode(rtv_rec.process_vat_in_batch, jai_constants.yes, ln_vat_batch_group_id)
2474: where transaction_id = rtv_rec.transaction_id;
2475: end if;