APPS.PER_GB_TERMINATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 77: FROM per_all_assignments_f asg,

73: CURSOR c_assignment_id(p_person_id number,
74: p_date_active date)
75: IS
76: SELECT assignment_id, assignment_number
77: FROM per_all_assignments_f asg,
78: per_assignment_status_types typ
79: WHERE asg.person_id = p_person_id
80: AND asg.period_of_service_id = p_period_of_service_id
81: AND asg.assignment_status_type_id = typ.assignment_status_type_id