APPS.OKL_LEASE_APP_PVT dependencies on OKL_CHECKLIST_DETAILS

Line 1318: p_cld_id IN OKL_CHECKLIST_DETAILS.ID%TYPE,

1314: -- End of comments
1315: PROCEDURE pop_checklist_item(
1316: p_api_version IN NUMBER,
1317: p_init_msg_list IN VARCHAR2,
1318: p_cld_id IN OKL_CHECKLIST_DETAILS.ID%TYPE,
1319: x_cldv_rec OUT NOCOPY OKL_CLD_PVT.CLDV_REC_TYPE,
1320: x_return_status OUT NOCOPY VARCHAR2,
1321: x_msg_count OUT NOCOPY NUMBER,
1322: x_msg_data OUT NOCOPY VARCHAR2)

Line 1365: FROM OKL_CHECKLIST_DETAILS CLD

1361: , CLD.DNZ_CHECKLIST_OBJ_ID DNZ_CHECKLIST_OBJ_ID
1362: , CLD.FUNCTION_ID FUNCTION_ID
1363: , CLD.INST_CHECKLIST_TYPE INST_CHECKLIST_TYPE
1364: , CLD.APPEAL_FLAG APPEAL_FLAG
1365: FROM OKL_CHECKLIST_DETAILS CLD
1366: WHERE CLD.ID = cp_cld_id;
1367: cld_db_val_rec cld_db_val_csr%ROWTYPE;
1368: BEGIN
1369: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2556: FROM OKL_CHECKLIST_DETAILS CHKD

2552: IS
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'