DBA Data[Home] [Help]

APPS.PQP_PENSION_EXTRACTS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 64: per_assignment_status_types ast

60: ,pps.date_start
61: ,pps.actual_termination_date
62: FROM per_all_assignments_f paf,
63: per_periods_of_service pps,
64: per_assignment_status_types ast
65: WHERE paf.assignment_id = c_assignment_id
66: AND pps.period_of_service_id(+) = paf.period_of_service_id
67: AND ast.assignment_status_type_id = paf.assignment_status_type_id
68: AND c_effective_date BETWEEN paf.effective_start_date