APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_RCV_RTV_DTLS

Line 2394: INSERT INTO JAI_RCV_RTV_DTLS(

2390: last_updated_by = fnd_global.user_id
2391: where current of c_rtv_trxs;
2392:
2393: lv_statement_id := '25';
2394: INSERT INTO JAI_RCV_RTV_DTLS(
2395: transaction_id, parent_transaction_id, shipment_line_id,
2396: excise_invoice_no, excise_invoice_date, rg_register_part_i,
2397: creation_date, created_by, last_update_date, last_updated_by, last_update_login
2398: ) VALUES (

Line 4025: FROM JAI_RCV_RTV_DTLS

4021: lv_codepath := jai_general_pkg.plot_codepath(21, lv_codepath);
4022: if r_trx.transaction_type = 'CORRECT' THEN
4023: lv_statement_id := '23';
4024: SELECT count(1) INTO ln_rtv_cnt
4025: FROM JAI_RCV_RTV_DTLS
4026: WHERE transaction_id = r_trx.parent_transaction_id;
4027:
4028: lv_statement_id := '24';
4029: if ln_rtv_cnt = 0 THEN