DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CSF_SKILL_LEVELS_B

Line 783: , csf_skill_levels_b rsl

779: , COUNT(*) count_of_matching_skills
780: , SUM( 1/rsl.step_value ) skill_level
781: FROM csf_resource_skills_b rs
782: , csf_required_skills_b ts
783: , csf_skill_levels_b rsl
784: , csf_skill_levels_b tsl
785: , csf_skills_b ss
786: WHERE DECODE(
787: SIGN(rsl.step_value - tsl.step_value)

Line 784: , csf_skill_levels_b tsl

780: , SUM( 1/rsl.step_value ) skill_level
781: FROM csf_resource_skills_b rs
782: , csf_required_skills_b ts
783: , csf_skill_levels_b rsl
784: , csf_skill_levels_b tsl
785: , csf_skills_b ss
786: WHERE DECODE(
787: SIGN(rsl.step_value - tsl.step_value)
788: , -1, DECODE(l_levelmatch, 1, 'Y', 'N')