APPS.CSF_GANTT_DATA_PKG dependencies on CSF_REQUIRED_SKILLS_B

Line 1872: , csf_required_skills_b ts

1868: , p_end
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(

Line 1910: FROM csf_required_skills_b

1906: WHERE msi.inventory_item_id = ts.skill_id)
1907: )
1908: GROUP BY rs.resource_id, rs.resource_type) rs
1909: , (SELECT COUNT(*) amount
1910: FROM csf_required_skills_b
1911: WHERE NVL(disabled_flag, 'N') <> 'Y'
1912: AND has_skill_type = 'TASK'
1913: AND has_skill_id = p_task_id) ts
1914: WHERE rs.amount = ts.amount AND rs.winstart <= rs.winend;