DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_SYSTEM_PARAMS_ALL

Line 1783: FROM OKL_SYSTEM_PARAMS_ALL

1779: AND PSU.ID2 = TXL.object_id2_new;
1780:
1781: CURSOR c_systemparams_csr(cp_org_id IN NUMBER) IS
1782: SELECT tax_upfront_yn
1783: FROM OKL_SYSTEM_PARAMS_ALL
1784: WHERE org_id = cp_org_id;
1785:
1786: CURSOR c_get_tax_amt_csr(cp_trx_id IN NUMBER,cp_khr_id IN NUMBER,cp_kle_id IN NUMBER) IS
1787: SELECT nvl(sum(total_tax) ,0)