APPS.HR_RU_UTILITY dependencies on HR_SOFT_CODING_KEYFLEX

Line 947: hr_soft_coding_keyflex scl

943: FROM SYS.dual
944: WHERE EXISTS (
945: SELECT '1'
946: FROM per_assignments_f paaf,
947: hr_soft_coding_keyflex scl
948: WHERE p_contract_number = scl.segment3
949: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
950: AND paaf.business_group_id IN (
951: --Select all business groups having leg. code RU

Line 995: hr_soft_coding_keyflex scl

991: FROM SYS.dual
992: WHERE EXISTS (
993: SELECT '1'
994: FROM per_all_assignments_f paaf,
995: hr_soft_coding_keyflex scl
996: WHERE (p_assignment_id IS NULL OR p_assignment_id <> paaf.assignment_id)
997: AND (nvl(scl.segment2,'N') = 'N' OR
998: paaf.soft_coding_keyflex_id IS NULL)
999: and paaf.person_id = p_person_id