DBA Data[Home] [Help]

APPS.CSFW_TASKS_PUB dependencies on CSF_REQUIRED_SKILLS_B

Line 205: FROM CSF_REQUIRED_SKILLS_B

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

Line 430: UPDATE CSF_REQUIRED_SKILLS_B

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