APPS.OKL_LEASE_APP_PVT dependencies on OKL_CHECKLIST_DETAILS

Line 1276: p_cld_id IN OKL_CHECKLIST_DETAILS.ID%TYPE,

1272: -- End of comments
1273: PROCEDURE pop_checklist_item(
1274: p_api_version IN NUMBER,
1275: p_init_msg_list IN VARCHAR2,
1276: p_cld_id IN OKL_CHECKLIST_DETAILS.ID%TYPE,
1277: x_cldv_rec OUT NOCOPY OKL_CLD_PVT.CLDV_REC_TYPE,
1278: x_return_status OUT NOCOPY VARCHAR2,
1279: x_msg_count OUT NOCOPY NUMBER,
1280: x_msg_data OUT NOCOPY VARCHAR2)

Line 1323: FROM OKL_CHECKLIST_DETAILS CLD

1319: , CLD.DNZ_CHECKLIST_OBJ_ID DNZ_CHECKLIST_OBJ_ID
1320: , CLD.FUNCTION_ID FUNCTION_ID
1321: , CLD.INST_CHECKLIST_TYPE INST_CHECKLIST_TYPE
1322: , CLD.APPEAL_FLAG APPEAL_FLAG
1323: FROM OKL_CHECKLIST_DETAILS CLD
1324: WHERE CLD.ID = cp_cld_id;
1325: cld_db_val_rec cld_db_val_csr%ROWTYPE;
1326: BEGIN
1327: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2514: FROM OKL_CHECKLIST_DETAILS CHKD

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