DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CSF_RESOURCE_SKILLS_B

Line 781: FROM csf_resource_skills_b rs

777: , p_end
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

Line 833: FROM csf_resource_skills_b rs2

829: AND mic.inventory_item_id = ts.skill_id
830: AND mic.category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET')
831: AND mic.category_id = ts2.skill_id)
832: AND NOT EXISTS (SELECT 1
833: FROM csf_resource_skills_b rs2
834: WHERE TRUNC(rs2.start_date_active) < p_end
835: AND (TRUNC(rs2.end_date_active + 1) > p_start OR rs2.end_date_active IS NULL)
836: AND rs2.resource_id = rs.resource_id
837: AND rs2.skill_id = ts.skill_id