APPS.OKL_FUNDING_PVT dependencies on OKL_CHECKLISTS

Line 589: ,okl_checklists hdr

585: chk.FUNCTION_ID,
586: chk.INST_CHECKLIST_TYPE
587: from OKL_CHECKLIST_DETAILS chk
588: --START:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242
589: ,okl_checklists hdr
590: where chk.ckl_id = hdr.id
591: and hdr.CHECKLIST_OBJ_ID = p_lease_app_id
592: --where chk.DNZ_CHECKLIST_OBJ_ID = p_lease_app_id
593: --END:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242

Line 601: ,okl_checklists hdr

597: cursor c_lease_app_list_exists (p_lease_app_id number) is
598: select 1
599: from OKL_CHECKLIST_DETAILS chk
600: --START:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242
601: ,okl_checklists hdr
602: where chk.ckl_id = hdr.id
603: and hdr.CHECKLIST_OBJ_ID = p_lease_app_id
604: --where chk.DNZ_CHECKLIST_OBJ_ID = p_lease_app_id
605: --END:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242

Line 9059: ,okl_checklists hdr

9055:
9056: cursor c_lease_app_list_exists (p_lease_app_id number) is
9057: select 1
9058: from OKL_CHECKLIST_DETAILS chk
9059: ,okl_checklists hdr
9060: where chk.ckl_id = hdr.id
9061: and hdr.CHECKLIST_OBJ_ID = p_lease_app_id
9062: and chk.INST_CHECKLIST_TYPE = 'FUNDING'
9063: ;