DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG2 dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 542: per_assignment_status_types ast

538:
539: cursor cur_loc is
540: select paf.location_id location_id
541: from per_assignments_f paf,
542: per_assignment_status_types ast
543: where paf.person_id = p_person_id
544: and p_effective_date
545: between paf.effective_start_date and paf.effective_end_date
546: and ast.assignment_status_type_id = paf.assignment_status_type_id