DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on CSF_REQUIRED_SKILLS_B

Line 4451: , csf_required_skills_b ts

4447: ) winend
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(

Line 4492: FROM csf_required_skills_b

4488: )
4489: GROUP BY rs.resource_id, rs.resource_type) rs
4490: , (
4491: SELECT COUNT(*) count_of_req_skills
4492: FROM csf_required_skills_b
4493: WHERE NVL(disabled_flag, 'N') <> 'Y'
4494: AND has_skill_type = 'TASK'
4495: AND has_skill_id = p_task_id
4496: ) ts