APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 889: per_assignment_status_types past

885:
886: cursor csr_asg_end_date is
887: select least(max(paf.effective_end_date),l_tax_year_end)
888: from per_all_assignments_f paf,
889: per_assignment_status_types past
890: where paf.assignment_id = p_assignment_id
891: and past.per_system_status = 'ACTIVE_ASSIGN'
892: and paf.assignment_status_type_id = past.assignment_status_type_id;
893: