APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 381: from JAI_CMN_MATCH_RECEIPTS a ,JAI_CMN_RG_23D_TRXS b

377: AND TAX_TYPE in ('Addl. Excise','Excise','Other Excise');
378:
379: cursor c_rcpts_match (cp_temp_id IN NUMBER) IS
380: select sum(a.quantity_applied) quantity_applied , sum(b.excise_duty_rate) excise_duty_rate
381: from JAI_CMN_MATCH_RECEIPTS a ,JAI_CMN_RG_23D_TRXS b
382: where a.receipt_id = b.register_id
383: and a.ref_line_id = cp_temp_id
384: and a.order_invoice = 'X';
385:

Line 4885: DELETE JAI_CMN_MATCH_RECEIPTS

4881: AND transaction_commit_date is null
4882: )
4883: AND order_invoice='X';
4884:
4885: DELETE JAI_CMN_MATCH_RECEIPTS
4886: WHERE ref_line_id IN
4887: (
4888: SELECT transaction_temp_id
4889: FROM jai_mtl_trxs

Line 4995: DELETE JAI_CMN_MATCH_RECEIPTS

4991: last_updated_by = ln_user_id
4992: WHERE transaction_header_id = p_header_id
4993: AND transaction_temp_id = p_line_id;
4994:
4995: DELETE JAI_CMN_MATCH_RECEIPTS
4996: WHERE ref_line_id = p_line_id
4997: AND order_invoice = 'X';
4998:
4999: DELETE jai_mtl_match_receipts