APPS.CSF_RESOURCE_PUB dependencies on CSF_REQUIRED_SKILLS_B

Line 647: , csf_required_skills_b ts

643: , p_end
644: ) winend
645: , COUNT(*) amount
646: FROM csf_resource_skills_b rs
647: , csf_required_skills_b ts
648: , csf_skill_levels_b rsl
649: , csf_skill_levels_b tsl
650: , csf_skills_b ss
651: WHERE DECODE(

Line 681: FROM csf_required_skills_b

677: WHERE msi.inventory_item_id = ts.skill_id)
678: )
679: GROUP BY rs.resource_id, rs.resource_type) rs
680: , (SELECT COUNT(*) amount
681: FROM csf_required_skills_b
682: WHERE NVL(disabled_flag, 'N') <> 'Y' AND has_skill_type = 'TASK'
683: AND has_skill_id = p_task_id) ts
684: WHERE rs.amount = ts.amount AND rs.winstart < rs.winend;
685: BEGIN

Line 1119: FROM csf_required_skills_b,jtf_tasks_b t

1115: -- Cursor to determine if the Task has any required skills
1116: -- and returns the has_skill_id
1117: CURSOR c_task_skills IS
1118: SELECT has_skill_id
1119: FROM csf_required_skills_b,jtf_tasks_b t
1120: WHERE t.task_id = p_task_id
1121: AND has_skill_type = 'TASK'
1122: AND has_skill_id = nvl(t.parent_task_id, t.task_id)
1123: AND NVL(disabled_flag, 'N') <> 'Y'