DBA Data[Home] [Help]

APPS.CSFW_TASKS_PUB dependencies on CSF_REQUIRED_SKILLS_B

Line 202: FROM CSF_REQUIRED_SKILLS_B

198: SELECT
199: SKILL_TYPE_ID
200: , SKILL_ID
201: , SKILL_LEVEL_ID , DISABLED_FLAG
202: FROM CSF_REQUIRED_SKILLS_B
203: WHERE HAS_SKILL_TYPE = 'TASK'
204: AND HAS_SKILL_ID = V_TASK_ID;
205:
206: R_FIND_SKILL FIND_SKILL%ROWTYPE;

Line 427: UPDATE CSF_REQUIRED_SKILLS_B

423: to update the row or set the DISABLE_FLAG while creating
424: To be removed once that is in. A bug is filed (# 3292940)
425: */
426: IF (R_FIND_SKILL.DISABLED_FLAG = 'Y') THEN
427: UPDATE CSF_REQUIRED_SKILLS_B
428: SET DISABLED_FLAG = 'Y'
429: WHERE SKILL_ID = R_FIND_SKILL.SKILL_ID
430: AND HAS_SKILL_ID = x_follow_up_task_id
431: AND SKILL_TYPE_ID = R_FIND_SKILL.SKILL_TYPE_ID