DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on CSF_SKILL_LEVELS_B

Line 4452: , csf_skill_levels_b rsl

4448: , COUNT(*) count_of_matching_skills
4449: , SUM( 1/rsl.step_value ) skill_level
4450: FROM csf_resource_skills_b rs
4451: , csf_required_skills_b ts
4452: , csf_skill_levels_b rsl
4453: , csf_skill_levels_b tsl
4454: , csf_skills_b ss
4455: WHERE DECODE(
4456: SIGN(rsl.step_value - tsl.step_value)

Line 4453: , csf_skill_levels_b tsl

4449: , SUM( 1/rsl.step_value ) skill_level
4450: FROM csf_resource_skills_b rs
4451: , csf_required_skills_b ts
4452: , csf_skill_levels_b rsl
4453: , csf_skill_levels_b tsl
4454: , csf_skills_b ss
4455: WHERE DECODE(
4456: SIGN(rsl.step_value - tsl.step_value)
4457: , -1, DECODE(l_levelmatch, 1, 'Y', 'N')