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 9058: from OKL_CHECKLIST_DETAILS chk

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