APPS.OKL_LEASE_APP_PVT dependencies on OKL_CHECKLISTS

Line 2502: FROM OKL_CHECKLISTS CHK

2498: ,CHK.START_DATE START_DATE
2499: ,CHK.END_DATE END_DATE
2500: ,CHK.DESCRIPTION
2501: ,CHK.SHORT_DESCRIPTION
2502: FROM OKL_CHECKLISTS CHK
2503: WHERE CHK.ID = cp_chk_id;
2504: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
2505:
2506: --Bug 4893077 PAGARG Querying checklist type from header while querying

Line 2515: , OKL_CHECKLISTS CHK

2511: SELECT CHKD.TODO_ITEM_CODE ITEM_CODE
2512: , CHK.CHECKLIST_TYPE CHECKLIST_TYPE
2513: , CHKD.FUNCTION_ID FUNCTION_ID
2514: FROM OKL_CHECKLIST_DETAILS CHKD
2515: , OKL_CHECKLISTS CHK
2516: WHERE CHKD.CKL_ID = CHK.ID
2517: --removing the condition for bug 5167776
2518: -- AND CHK.CHECKLIST_PURPOSE_CODE <> 'CHECKLIST_INSTANCE'
2519: AND (CHK.ID = cp_chk_id OR CHK.CKL_ID = cp_chk_id );

Line 2530: FROM OKL_CHECKLISTS CHK

2526: ,CHK.END_DATE END_DATE
2527: ,CHK.DESCRIPTION DESCRIPTION
2528: ,CHK.SHORT_DESCRIPTION SHORT_DESCRIPTION
2529: ,CHK.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
2530: FROM OKL_CHECKLISTS CHK
2531: WHERE CHK.CHECKLIST_OBJ_TYPE_CODE = 'LEASE_APPL'
2532: AND CHK.CHECKLIST_OBJ_ID = cp_lap_id;
2533: lap_chk_dtls_rec lap_chk_dtls_csr%ROWTYPE;
2534:

Line 4232: FROM OKL_CHECKLISTS CHK

4228: --Validate Checklist Cursor
4229: CURSOR checklist_val_csr(p_latv_id NUMBER, p_valid_from DATE)
4230: IS
4231: SELECT CHECKLIST_NUMBER TEMPLATE_NUMBER
4232: FROM OKL_CHECKLISTS CHK
4233: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4234: , OKL_LEASEAPP_TEMPLATES LAT
4235: WHERE LATV.CHECKLIST_ID = CHK.ID
4236: AND LATV.LEASEAPP_TEMPLATE_ID = LAT.ID

Line 9144: , OKL_CHECKLISTS CHK

9140: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
9141: IS
9142: SELECT CHK.ID CHECKLIST_ID
9143: FROM OKL_LEASE_APPLICATIONS_B LAP
9144: , OKL_CHECKLISTS CHK
9145: WHERE CHK.CHECKLIST_OBJ_TYPE_CODE = 'LEASE_APPL'
9146: AND CHK.CHECKLIST_OBJ_ID = LAP.ID
9147: AND LAP.ID = cp_lap_id;
9148: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;