APPS.CSF_RESOURCE_PUB dependencies on CSF_REQUIRED_SKILLS_B

Line 782: , csf_required_skills_b ts

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

Line 822: FROM csf_required_skills_b ts2

818: AND category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET'))
819: /* OR ts.skill_type_id = 2
820: AND rs.skill_type_id = 3
821: AND NOT EXISTS (SELECT 1
822: FROM csf_required_skills_b ts2
823: , mtl_item_categories mic
824: WHERE NVL(ts2.disabled_flag, 'N') <> 'Y'
825: AND ts2.has_skill_type = ts.has_skill_type
826: AND ts2.has_skill_id = ts.has_skill_id

Line 848: FROM csf_required_skills_b

844: )
845: GROUP BY rs.resource_id, rs.resource_type) rs
846: , (
847: SELECT COUNT(*) count_of_req_skills
848: FROM csf_required_skills_b
849: WHERE NVL(disabled_flag, 'N') <> 'Y'
850: AND has_skill_type = 'TASK'
851: AND has_skill_id = p_task_id
852: ) ts

Line 1300: FROM csf_required_skills_b,jtf_tasks_b t

1296: -- Cursor to determine if the Task has any required skills
1297: -- and returns the has_skill_id
1298: CURSOR c_task_skills IS
1299: SELECT has_skill_id
1300: FROM csf_required_skills_b,jtf_tasks_b t
1301: WHERE t.task_id = p_task_id
1302: AND has_skill_type = 'TASK'
1303: AND has_skill_id = nvl(t.parent_task_id, t.task_id)
1304: AND NVL(disabled_flag, 'N') <> 'Y'