DBA Data[Home] [Help]

APPS.JAI_RCV_RT_TRIGGER_PKG dependencies on JAI_RCV_LINE_TAXES

Line 23: from JAI_RCV_LINE_TAXES

19:
20:
21: cursor c_get_tax_count(p_shipment_header_id number, p_shipment_line_id number) is
22: select count(1)
23: from JAI_RCV_LINE_TAXES
24: where shipment_header_id = p_shipment_header_id
25: and shipment_line_id = p_shipment_line_id;
26:
27:

Line 858: UPDATE JAI_RCV_LINE_TAXES

854: WHERE shipment_line_id = pr_new.shipment_line_id;
855:
856: /* following added as part of VAT Impl. Changes */
857: IF pr_new.transaction_type = 'MATCH' THEN
858: UPDATE JAI_RCV_LINE_TAXES
859: SET transaction_id = pr_new.transaction_id
860: , last_update_date = sysdate
861: , last_updated_by = fnd_global.user_id
862: WHERE shipment_line_id = pr_new.shipment_line_id