APPS.JAI_PO_PROC_PKG dependencies on JAI_CMN_TAXES_ALL

Line 161: FROM jai_cmn_taxes_all

157: ORDER BY tax_line_no;
158:
159: CURSOR fetch_mod_cr_cur(taxid IN NUMBER) IS
160: SELECT tax_type, mod_cr_percentage, vendor_id, adhoc_flag
161: FROM jai_cmn_taxes_all
162: WHERE tax_id = taxid;
163:
164: CURSOR c_line_tax_category_id(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
165: SELECT tax_category_id

Line 799: AND EXISTS (select 1 from JAI_CMN_TAXES_ALL b where b.tax_id = a.tax_id and b.adhoc_flag = 'Y');

795: UPDATE JAI_PO_TAXES a
796: SET tax_amount = (tax_amount * v_qty/ v_old_qty ),
797: tax_target_amount = (tax_target_amount * v_qty/ v_old_qty)
798: WHERE line_location_id = v_line_loc_id
799: AND EXISTS (select 1 from JAI_CMN_TAXES_ALL b where b.tax_id = a.tax_id and b.adhoc_flag = 'Y');
800:
801:
802: insert_jai_line_locs(
803: v_line_loc_id => v_line_loc_id

Line 1408: from JAI_CMN_TAXES_ALL

1404: AND line_location_id = p_line_location_id;
1405:
1406: CURSOR c_check_adhoc_flag(p_tax_id number) IS
1407: select nvl(adhoc_flag,'N')
1408: from JAI_CMN_TAXES_ALL
1409: where tax_id = p_tax_id;
1410:
1411:
1412: CURSOR cur_vendor_curr

Line 1425: v_check_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type;

1421: SELECT ITEM_ID
1422: FROM po_lines_all
1423: WHERE po_line_id = p_po_line_id;*/
1424:
1425: v_check_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type;
1426: v_tax_amount NUMBER;
1427:
1428: BEGIN
1429:

Line 3969: JAI_CMN_TAXES_ALL jt

3965:
3966: SELECT SUM(jr.TAX_AMOUNT)
3967: INTO v_exclu_tax_amount
3968: FROM JAI_PO_REQ_LINE_TAXES jr,
3969: JAI_CMN_TAXES_ALL jt
3970: WHERE jr.Requisition_Header_Id = pr_requisition_line.requisition_header_id
3971: AND jr.Requisition_Line_Id = pr_requisition_line.Requisition_Line_Id
3972: AND jr.tax_id = jt.tax_id
3973: AND jr.Tax_Type <> jai_constants.tax_type_tds

Line 4351: JAI_CMN_TAXES_ALL jt

4347:
4348: SELECT SUM(jr.TAX_AMOUNT)
4349: INTO v_exclu_tax_amount
4350: FROM JAI_PO_REQ_LINE_TAXES jr,
4351: JAI_CMN_TAXES_ALL jt
4352: WHERE jr.Requisition_Header_Id = pr_requisition_line.requisition_header_id
4353: AND jr.Requisition_Line_Id = pr_requisition_line.Requisition_Line_Id
4354: AND jr.tax_id = jt.tax_id
4355: AND jr.Tax_Type <> jai_constants.tax_type_tds

Line 4901: FROM JAI_CMN_TAXES_ALL

4897: rec_tax Fetch_Taxes_Cur%ROWTYPE;
4898: CURSOR Fetch_Mod_Cr_Cur( taxid IN NUMBER ) IS
4899: SELECT Tax_Type, Mod_Cr_Percentage, Vendor_Id
4900: , adhoc_flag
4901: FROM JAI_CMN_TAXES_ALL
4902: WHERE Tax_Id = taxid;
4903:
4904: CURSOR Fetch_Vendor_Id IS
4905: SELECT Vendor_Id

Line 6380: FROM JAI_CMN_TAXES_ALL

6376: v_tax_target NUMBER;
6377:
6378: CURSOR cur_taxes_adhoc(cp_tax_id number) IS
6379: SELECT adhoc_flag
6380: FROM JAI_CMN_TAXES_ALL
6381: WHERE tax_id = cp_tax_id;
6382:
6383: lv_adhoc_flag varchar2(1);
6384:

Line 7561: JAI_CMN_TAXES_ALL b

7557: nvl(a.tax_amount,0) tax_amount,
7558: nvl(b.adhoc_flag, 'N') adhoc_flag
7559: FROM
7560: JAI_PO_TAXES a ,
7561: JAI_CMN_TAXES_ALL b
7562: WHERE
7563: a.tax_id = b.tax_id AND
7564: a.po_line_id = v_po_line_id AND
7565: a.po_header_id = v_po_hdr_id AND

Line 8329: FROM JAI_CMN_TAXES_ALL

8325: rec_tax Fetch_Taxes_Cur%ROWTYPE;
8326: CURSOR Fetch_Mod_Cr_Cur( taxid IN NUMBER ) IS
8327: SELECT Tax_Type, Mod_Cr_Percentage, Vendor_Id
8328: , adhoc_flag
8329: FROM JAI_CMN_TAXES_ALL
8330: WHERE Tax_Id = taxid;
8331:
8332: CURSOR Fetch_Vendor_Id IS
8333: SELECT Vendor_Id