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 850: DELETE FROM JAI_PO_TAXES

846: FETCH Fetch_Flag_Cur INTO v_t_flag;
847: EXIT WHEN Fetch_Flag_Cur%NOTFOUND;
848: IF UPPER( v_t_flag ) = 'N' THEN
849:
850: DELETE FROM JAI_PO_TAXES
851: WHERE Line_Location_Id = v_line_loc_id;
852:
853: jai_po_cmn_pkg.insert_line( 'CATALOG',
854: v_line_loc_id,