APPS.JAI_PO_LA_TRIGGER_PKG dependencies on JAI_PO_TAXES

Line 37: FROM JAI_PO_TAXES

33: dummy NUMBER;
34:
35:
36: CURSOR Check_Llid_Cur IS SELECT COUNT( Line_Location_Id )
37: FROM JAI_PO_TAXES
38: WHERE Po_Line_Id = v_po_line_id;
39:
40: /* Bug 5243532. Added by Lakshmi Gopalsami
41: * Defined variable for implementing caching logic.

Line 102: DELETE FROM JAI_PO_TAXES

98: FETCH Check_Llid_Cur INTO dummy;
99: CLOSE Check_Llid_Cur;
100:
101: IF NVL( dummy, 0 ) > 0 THEN
102: DELETE FROM JAI_PO_TAXES
103: WHERE Po_Line_Id = v_po_line_id;
104: END IF;
105: END ARD_T1 ;
106:

Line 793: DELETE FROM JAI_PO_TAXES

789: FETCH Fetch_Flag_Cur INTO v_t_flag;
790: EXIT WHEN Fetch_Flag_Cur%NOTFOUND;
791: IF UPPER( v_t_flag ) = 'N' THEN
792:
793: DELETE FROM JAI_PO_TAXES
794: WHERE Line_Location_Id = v_line_loc_id;
795:
796: jai_po_cmn_pkg.insert_line( 'CATALOG',
797: v_line_loc_id,