DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_SYSTEM_PARAMS_ALL

Line 1815: FROM OKL_SYSTEM_PARAMS_ALL

1811: AND PSU.ID2 = TXL.object_id2_new;
1812:
1813: CURSOR c_systemparams_csr(cp_org_id IN NUMBER) IS
1814: SELECT tax_upfront_yn
1815: FROM OKL_SYSTEM_PARAMS_ALL
1816: WHERE org_id = cp_org_id;
1817:
1818: CURSOR c_get_tax_amt_csr(cp_trx_id IN NUMBER,cp_khr_id IN NUMBER,cp_kle_id IN NUMBER) IS
1819: SELECT nvl(sum(total_tax) ,0)