DBA Data[Home] [Help]

APPS.HR_AU_ROUTES dependencies on PER_ALL_ASSIGNMENTS_F

Line 126: , per_all_assignments_f paaf

122: --
123: cursor csr_ann_date is
124: select to_date(segment2,'YYYY/MM/DD HH24:MI:SS')
125: from hr_soft_coding_keyflex hsck
126: , per_all_assignments_f paaf
127: , pay_assignment_actions_v paav
128: where p_effective_date between paaf.effective_start_date and paaf.effective_end_date
129: and paav.assignment_action_id = p_assignment_action_id
130: and paav.assignment_id = paaf.assignment_id