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 8837: ,okl_checklists hdr

8833:
8834: cursor c_lease_app_list_exists (p_lease_app_id number) is
8835: select 1
8836: from OKL_CHECKLIST_DETAILS chk
8837: ,okl_checklists hdr
8838: where chk.ckl_id = hdr.id
8839: and hdr.CHECKLIST_OBJ_ID = p_lease_app_id
8840: and chk.INST_CHECKLIST_TYPE = 'FUNDING'
8841: ;