APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 504: from JAI_CMN_MATCH_RECEIPTS a ,JAI_CMN_RG_23D_TRXS b

500: AND TAX_TYPE in ('Addl. Excise','Excise','Other Excise');
501:
502: cursor c_rcpts_match (cp_temp_id IN NUMBER) IS
503: select sum(a.quantity_applied) quantity_applied , sum(b.excise_duty_rate) excise_duty_rate
504: from JAI_CMN_MATCH_RECEIPTS a ,JAI_CMN_RG_23D_TRXS b
505: where a.receipt_id = b.register_id
506: and a.ref_line_id = cp_temp_id
507: and a.order_invoice = 'X';
508:

Line 5328: DELETE JAI_CMN_MATCH_RECEIPTS

5324: AND transaction_commit_date is null
5325: )
5326: AND order_invoice='X';
5327:
5328: DELETE JAI_CMN_MATCH_RECEIPTS
5329: WHERE ref_line_id IN
5330: (
5331: SELECT transaction_temp_id
5332: FROM jai_mtl_trxs

Line 5455: DELETE JAI_CMN_MATCH_RECEIPTS

5451: last_updated_by = ln_user_id
5452: WHERE transaction_header_id = p_header_id
5453: AND transaction_temp_id = p_line_id;
5454:
5455: DELETE JAI_CMN_MATCH_RECEIPTS
5456: WHERE ref_line_id = p_line_id
5457: AND order_invoice = 'X';
5458:
5459: DELETE jai_mtl_match_receipts