APPS.OKL_LEASE_APP_PVT dependencies on OKL_CHECKLISTS

Line 2544: FROM OKL_CHECKLISTS CHK

2540: ,CHK.START_DATE START_DATE
2541: ,CHK.END_DATE END_DATE
2542: ,CHK.DESCRIPTION
2543: ,CHK.SHORT_DESCRIPTION
2544: FROM OKL_CHECKLISTS CHK
2545: WHERE CHK.ID = cp_chk_id;
2546: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
2547:
2548: --Bug 4893077 PAGARG Querying checklist type from header while querying

Line 2557: , OKL_CHECKLISTS CHK

2553: SELECT CHKD.TODO_ITEM_CODE ITEM_CODE
2554: , CHK.CHECKLIST_TYPE CHECKLIST_TYPE
2555: , CHKD.FUNCTION_ID FUNCTION_ID
2556: FROM OKL_CHECKLIST_DETAILS CHKD
2557: , OKL_CHECKLISTS CHK
2558: WHERE CHKD.CKL_ID = CHK.ID
2559: --removing the condition for bug 5167776
2560: -- AND CHK.CHECKLIST_PURPOSE_CODE <> 'CHECKLIST_INSTANCE'
2561: AND (CHK.ID = cp_chk_id OR CHK.CKL_ID = cp_chk_id );

Line 2572: FROM OKL_CHECKLISTS CHK

2568: ,CHK.END_DATE END_DATE
2569: ,CHK.DESCRIPTION DESCRIPTION
2570: ,CHK.SHORT_DESCRIPTION SHORT_DESCRIPTION
2571: ,CHK.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
2572: FROM OKL_CHECKLISTS CHK
2573: WHERE CHK.CHECKLIST_OBJ_TYPE_CODE = 'LEASE_APPL'
2574: AND CHK.CHECKLIST_OBJ_ID = cp_lap_id;
2575: lap_chk_dtls_rec lap_chk_dtls_csr%ROWTYPE;
2576:

Line 4320: FROM OKL_CHECKLISTS CHK

4316: --Validate Checklist Cursor
4317: CURSOR checklist_val_csr(p_latv_id NUMBER, p_valid_from DATE)
4318: IS
4319: SELECT CHECKLIST_NUMBER TEMPLATE_NUMBER
4320: FROM OKL_CHECKLISTS CHK
4321: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4322: , OKL_LEASEAPP_TEMPLATES LAT
4323: WHERE LATV.CHECKLIST_ID = CHK.ID
4324: AND LATV.LEASEAPP_TEMPLATE_ID = LAT.ID

Line 9275: , OKL_CHECKLISTS CHK

9271: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
9272: IS
9273: SELECT CHK.ID CHECKLIST_ID
9274: FROM OKL_LEASE_APPLICATIONS_B LAP
9275: , OKL_CHECKLISTS CHK
9276: WHERE CHK.CHECKLIST_OBJ_TYPE_CODE = 'LEASE_APPL'
9277: AND CHK.CHECKLIST_OBJ_ID = LAP.ID
9278: AND LAP.ID = cp_lap_id;
9279: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;