DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on OKL_VP_ASSOCIATIONS_V

Line 4267: , OKL_VP_ASSOCIATIONS_V VPA

4263: --Bug abhsaxen 5158188 for validation of VPA is having any LAT
4264: CURSOR lat_pgm_exist_csr(cp_pgm_agr_id NUMBER) IS
4265: SELECT 'X'
4266: FROM OKC_K_HEADERS_B PGM
4267: , OKL_VP_ASSOCIATIONS_V VPA
4268: , OKL_LEASEAPP_TEMPLATES LAT
4269: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4270: WHERE VPA.CHR_ID = PGM.ID
4271: AND VPA.CRS_ID IS NULL

Line 4283: , OKL_VP_ASSOCIATIONS_V VPA

4279: --Bug 4873205 PAGARG modified the query to validate validation
4280: CURSOR lat_pgm_val_csr(cp_pgm_agr_id NUMBER, cp_latv_id NUMBER) IS
4281: SELECT 'X'
4282: FROM OKC_K_HEADERS_B PGM
4283: , OKL_VP_ASSOCIATIONS_V VPA
4284: , OKL_LEASEAPP_TEMPLATES LAT
4285: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4286: WHERE VPA.CHR_ID = PGM.ID
4287: AND VPA.CRS_ID IS NULL