APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

Line 1070: FROM JAI_CMN_TAXES_ALL

1066:
1067: CURSOR Fetch_Mod_Cr_Cur( taxid IN NUMBER ) IS
1068: SELECT Tax_Type, Mod_Cr_Percentage, Vendor_Id
1069: , adhoc_flag -- Vijay Shankar for Bug# 2782356
1070: FROM JAI_CMN_TAXES_ALL
1071: WHERE Tax_Id = taxid;
1072:
1073: CURSOR Fetch_Vendor_Id IS
1074: SELECT Vendor_Id

Line 1946: FROM JAI_CMN_TAXES_ALL

1942: -- AND NVL(A.Org_Id,0) = NVL(v_org_id,0);
1943:
1944: CURSOR tax_rate_cur(p_tax_id IN NUMBER) IS
1945: SELECT Tax_Rate, Tax_Amount, Uom_Code, Tax_Type
1946: FROM JAI_CMN_TAXES_ALL
1947: WHERE Tax_Id = p_tax_id;
1948:
1949: CURSOR Fetch_Hdr_Curr_Cur IS SELECT NVL( Currency_Code, '$' )
1950: FROM Po_Requisition_Headers_V

Line 2647: FROM JAI_CMN_TAXES_ALL --ja_in_tax_codes

2643: pr_old.rate_date, pr_old.rate_type, pr_old.rate ),conv_rate)
2644: WHERE requisition_header_id = v_header_id
2645: AND requisition_line_id = v_line_id
2646: AND exists ( SELECT 1
2647: FROM JAI_CMN_TAXES_ALL --ja_in_tax_codes
2648: WHERE tax_id = jrtl.tax_id
2649: AND adhoc_flag = 'Y'
2650: );
2651:

Line 2780: FROM JAI_CMN_TAXES_ALL

2776: AND nvl(A.Org_Id,0) = nvl(v_org_id,0);
2777:
2778: Cursor tax_rate_cur(p_tax_id IN NUMBER) IS
2779: SELECT Tax_Rate, Tax_Amount, Uom_Code, Tax_Type
2780: FROM JAI_CMN_TAXES_ALL
2781: WHERE Tax_Id = p_tax_id;
2782:
2783: CURSOR Fetch_Hdr_Curr_Cur IS SELECT NVL( Currency_Code, '$' )
2784: FROM Po_Requisition_Headers_V