APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 850: per_assignment_status_types past

846:
847: cursor csr_asg_end_date is
848: select least(max(paf.effective_end_date),l_tax_year_end)
849: from per_all_assignments_f paf,
850: per_assignment_status_types past
851: where paf.assignment_id = p_assignment_id
852: and past.per_system_status = 'ACTIVE_ASSIGN'
853: and paf.assignment_status_type_id = past.assignment_status_type_id;
854: