APPS.CSFW_TASKS_PUB dependencies on CSF_ACCESS_HOURS_VL

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

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

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

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