DBA Data[Home] [Help]

APPS.HR_RU_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 994: FROM per_all_assignments_f paaf,

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