DBA Data[Home] [Help]

APPS.BEN_ELEMENT_ENTRY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1164: FROM per_all_assignments_f asg, per_assignment_status_types ast

1160: )
1161: IS
1162: SELECT asg.assignment_id, asg.payroll_id, asg.organization_id,
1163: asg.effective_start_date, asg.effective_end_date
1164: FROM per_all_assignments_f asg, per_assignment_status_types ast
1165: WHERE asg.person_id = c_person_id
1166: AND asg.assignment_type <> 'C'
1167: AND asg.primary_flag = 'Y'
1168: AND asg.assignment_status_type_id = ast.assignment_status_type_id