[Home] [Help]
1869: ) winend
1870: , COUNT(*) amount
1871: FROM csf_resource_skills_b rs
1872: , csf_required_skills_b ts
1873: , csf_skill_levels_b rsl
1874: , csf_skill_levels_b tsl
1875: , csf_skills_b ss
1876: WHERE DECODE(
1877: SIGN(rsl.step_value - tsl.step_value)
1870: , COUNT(*) amount
1871: FROM csf_resource_skills_b rs
1872: , csf_required_skills_b ts
1873: , csf_skill_levels_b rsl
1874: , csf_skill_levels_b tsl
1875: , csf_skills_b ss
1876: WHERE DECODE(
1877: SIGN(rsl.step_value - tsl.step_value)
1878: , -1, DECODE(l_levelmatch, 1, 'Y', 'N')