APPS.HR_RU_UTILITY dependencies on HR_SOFT_CODING_KEYFLEX

Line 950: hr_soft_coding_keyflex scl

946: FROM SYS.dual
947: WHERE EXISTS (
948: SELECT '1'
949: FROM per_assignments_f paaf,
950: hr_soft_coding_keyflex scl
951: WHERE (paaf.assignment_id <> p_assignment_id
952: or
953: p_assignment_id is null)
954: and p_contract_number = scl.segment3

Line 1001: hr_soft_coding_keyflex scl

997: FROM SYS.dual
998: WHERE EXISTS (
999: SELECT '1'
1000: FROM per_all_assignments_f paaf,
1001: hr_soft_coding_keyflex scl
1002: WHERE (p_assignment_id IS NULL OR p_assignment_id <> paaf.assignment_id)
1003: AND (nvl(scl.segment2,'N') = 'N' OR
1004: paaf.soft_coding_keyflex_id IS NULL)
1005: and paaf.person_id = p_person_id