APPS.CSFW_TASKS_PUB dependencies on CSF_ACCESS_HOURS_VL

Line 211: CURSOR C_CST_ACCESS_HRS_EXISTS(v_task_id number) is select 'Y' from csf_access_hours_vl where task_id=v_task_id;

207: AND HAS_SKILL_ID = V_TASK_ID;
208:
209: R_FIND_SKILL FIND_SKILL%ROWTYPE;
210:
211: CURSOR C_CST_ACCESS_HRS_EXISTS(v_task_id number) is select 'Y' from csf_access_hours_vl where task_id=v_task_id;
212: CURSOR C_CST_ACCESS_HRS(v_task_id number) IS select * from CSF_ACCESS_HOURS_VL where task_id = v_task_id;
213:
214: R_CST_HRS C_CST_ACCESS_HRS%ROWTYPE;
215:

Line 212: CURSOR C_CST_ACCESS_HRS(v_task_id number) IS select * from CSF_ACCESS_HOURS_VL where task_id = v_task_id;

208:
209: R_FIND_SKILL FIND_SKILL%ROWTYPE;
210:
211: CURSOR C_CST_ACCESS_HRS_EXISTS(v_task_id number) is select 'Y' from csf_access_hours_vl where task_id=v_task_id;
212: CURSOR C_CST_ACCESS_HRS(v_task_id number) IS select * from CSF_ACCESS_HOURS_VL where task_id = v_task_id;
213:
214: R_CST_HRS C_CST_ACCESS_HRS%ROWTYPE;
215:
216: CURSOR c_task_location (v_task_id NUMBER)