APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 330: per_assignment_status_types past

326:
327: CURSOR csr_asg_end_date IS
328: select least(max(paf.effective_end_date),l_ext_end_date)
329: from per_all_assignments_f paf,
330: per_assignment_status_types past
331: where paf.assignment_id = p_assignment_id
332: and past.per_system_status = 'ACTIVE_ASSIGN'
333: and paf.assignment_status_type_id = past.assignment_status_type_id;
334: BEGIN