DBA Data[Home] [Help]

APPS.OKL_FUNDING_PVT dependencies on OKL_CHECKLIST_DETAILS

Line 587: from OKL_CHECKLIST_DETAILS chk

583: NVL(chk.MANDATORY_FLAG, 'N') MANDATORY_FLAG,
584: chk.USER_NOTE,
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

Line 599: from OKL_CHECKLIST_DETAILS chk

595: ;
596:
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

Line 8836: from OKL_CHECKLIST_DETAILS chk

8832: ;
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'