DBA Data[Home] [Help]

APPS.HR_RU_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 1000: FROM per_all_assignments_f paaf,

996: INTO l_status
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)