DBA Data[Home] [Help]

APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_POOL_PVT

Line 133: AND ia_pool_c.status_code <> Okl_Pool_Pvt.G_POC_STS_PENDING ; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)

129: AND ia_chr.id = ia_khr.id
130: AND ia_pdt.id = ia_khr.pdt_id
131: AND ia_chr.id = ia_khr.id
132: AND ia_pool_c.khr_id = p_khr_id
133: AND ia_pool_c.status_code <> Okl_Pool_Pvt.G_POC_STS_PENDING ; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
134: -- Cursor to fetch IA Accounting Code setup in Terms and Conditions..
135: CURSOR c_investor_agree_acc_code_csr (l_rent_ia_chr_id NUMBER, l_res_ia_chr_id NUMBER)
136: IS
137: SELECT