DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on OKL_VP_ASSOCIATIONS_V

Line 4179: , OKL_VP_ASSOCIATIONS_V VPA

4175: --Bug abhsaxen 5158188 for validation of VPA is having any LAT
4176: CURSOR lat_pgm_exist_csr(cp_pgm_agr_id NUMBER) IS
4177: SELECT 'X'
4178: FROM OKC_K_HEADERS_B PGM
4179: , OKL_VP_ASSOCIATIONS_V VPA
4180: , OKL_LEASEAPP_TEMPLATES LAT
4181: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4182: WHERE VPA.CHR_ID = PGM.ID
4183: AND VPA.CRS_ID IS NULL

Line 4195: , OKL_VP_ASSOCIATIONS_V VPA

4191: --Bug 4873205 PAGARG modified the query to validate validation
4192: CURSOR lat_pgm_val_csr(cp_pgm_agr_id NUMBER, cp_latv_id NUMBER) IS
4193: SELECT 'X'
4194: FROM OKC_K_HEADERS_B PGM
4195: , OKL_VP_ASSOCIATIONS_V VPA
4196: , OKL_LEASEAPP_TEMPLATES LAT
4197: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4198: WHERE VPA.CHR_ID = PGM.ID
4199: AND VPA.CRS_ID IS NULL