APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

Line 983: FROM JAI_CMN_TAXES_ALL

979:
980: CURSOR Fetch_Mod_Cr_Cur( taxid IN NUMBER ) IS
981: SELECT Tax_Type, Mod_Cr_Percentage, Vendor_Id
982: , adhoc_flag -- Vijay Shankar for Bug# 2782356
983: FROM JAI_CMN_TAXES_ALL
984: WHERE Tax_Id = taxid;
985:
986: CURSOR Fetch_Vendor_Id IS
987: SELECT Vendor_Id

Line 1815: FROM JAI_CMN_TAXES_ALL

1811: -- AND NVL(A.Org_Id,0) = NVL(v_org_id,0);
1812:
1813: CURSOR tax_rate_cur(p_tax_id IN NUMBER) IS
1814: SELECT Tax_Rate, Tax_Amount, Uom_Code, Tax_Type
1815: FROM JAI_CMN_TAXES_ALL
1816: WHERE Tax_Id = p_tax_id;
1817:
1818: CURSOR Fetch_Hdr_Curr_Cur IS SELECT NVL( Currency_Code, '$' )
1819: FROM Po_Requisition_Headers_V

Line 2429: FROM JAI_CMN_TAXES_ALL --ja_in_tax_codes

2425: pr_old.rate_date, pr_old.rate_type, pr_old.rate ),conv_rate)
2426: WHERE requisition_header_id = v_header_id
2427: AND requisition_line_id = v_line_id
2428: AND exists ( SELECT 1
2429: FROM JAI_CMN_TAXES_ALL --ja_in_tax_codes
2430: WHERE tax_id = jrtl.tax_id
2431: AND adhoc_flag = 'Y'
2432: );
2433:

Line 2557: FROM JAI_CMN_TAXES_ALL

2553: AND nvl(A.Org_Id,0) = nvl(v_org_id,0);
2554:
2555: Cursor tax_rate_cur(p_tax_id IN NUMBER) IS
2556: SELECT Tax_Rate, Tax_Amount, Uom_Code, Tax_Type
2557: FROM JAI_CMN_TAXES_ALL
2558: WHERE Tax_Id = p_tax_id;
2559:
2560: CURSOR Fetch_Hdr_Curr_Cur IS SELECT NVL( Currency_Code, '$' )
2561: FROM Po_Requisition_Headers_V