[Home] [Help]
112: a.precedence_6 p_6, a.precedence_7 p_7, a.precedence_8 p_8,a.precedence_9 p_9, a.precedence_10 p_10,
113: a.currency, a.tax_rate, a.qty_rate, a.uom, a.tax_amount, a.tax_type,
114: a.vendor_id, a.modvat_flag,
115: tax_category_id -- cbabu for EnhancementBug# 2427465
116: FROM JAI_PO_TAXES a
117: WHERE a.line_location_id = p_line_location_id
118: ORDER BY a.tax_line_no;
119:
120: -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
124: a.precedence_6 p_6, a.precedence_7 p_7, a.precedence_8 p_8, a.precedence_9 p_9, a.precedence_10 p_10,
125: a.currency, a.tax_rate, a.qty_rate, a.uom, a.tax_amount, a.tax_type,
126: a.vendor_id, a.modvat_flag,
127: tax_category_id -- cbabu for EnhancementBug# 2427465
128: FROM JAI_PO_TAXES a
129: WHERE a.po_line_id = v_po_line_id
130: AND Line_Location_Id IS NULL
131: ORDER BY a.tax_line_no;*/
132: --pramasub commented for FP end
152: a.tax_type ,
153: a.vendor_id ,
154: a.modvat_flag ,
155: tax_category_id -- cbabu for EnhancementBug# 2427465
156: FROM JAI_PO_TAXES a --Ja_In_Po_Line_Location_Taxes a
157: WHERE po_line_id = p_po_line_id
158: AND nvl(line_location_id,-999) = p_line_location_id
159: ORDER BY a.tax_line_no; --new cursor added by pramasub for FP
160:
892: v_assessable_value NUMBER;
893: ln_vat_assess_value NUMBER; -- added rallamse bug#4250072 VAT
894: v_loc_count NUMBER;--File.Sql.35 Cbabu := 0; --new variable for loc chk on 17-aug-00
895:
896: v_tax_category_id JAI_PO_TAXES.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
897: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
898: v_style_id po_headers_all.style_id%TYPE; --Added by Sanjikum for Bug#4483042
899:
900: ------------------------------>
992:
993:
994: CURSOR Tot_Amt_Cur IS
995: SELECT SUM( NVL( Tax_Amount, 0 ) )
996: FROM JAI_PO_TAXES
997: WHERE line_location_id = v_line_loc_id
998: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS'; Ramananda for removal of SQL LITERALs */
999:
1000: -- Start Modification by Gaurav for PO Autocreate issue 17-aug-00
1055: AND Line_Location_Id = line_loc_id;
1056:
1057: Cursor fetch_Tax_cnt( cp_line_loc_id in number ) is
1058: select count(1)
1059: from JAI_PO_TAXES
1060: where line_location_id = cp_line_loc_id;
1061:
1062: /* Bug 5243532. Added by Lakshmi Gopalsami
1063: * Removed cursors Fetch_Book_Id and used po_requisition_headers_v
1422:
1423:
1424: IF NVL(lv_tax_modified_flag,'N') = 'N' THEN --added, Bgowrava for Bug#6084636
1425:
1426: DELETE FROM JAI_PO_TAXES
1427: WHERE line_location_id = pr_new.line_location_id;
1428:
1429: IF v_debug THEN -- bug 7218695. Added by Lakshmi Gopalsami
1430:
1602: END IF;
1603: END IF;
1604:
1605: -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
1606: INSERT INTO JAI_PO_TAXES(
1607: line_focus_id, line_location_id, tax_line_no, po_line_id, po_header_id,
1608: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
1609: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
1610: tax_id, currency, tax_rate, qty_rate, uom,
1864: a.vendor_id ,
1865: a.modvat_flag ,
1866: tax_category_id
1867: --FROM Ja_In_Po_Line_Location_Taxes a
1868: FROM JAI_PO_TAXES a
1869: WHERE po_line_id = p_po_line_id
1870: AND nvl(line_location_id,-999) = p_line_location_id
1871: ORDER BY a.tax_line_no;
1872: