DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 73: per_assignment_status_types ast

69: ,'PPG_CODE'
70: ,'PAY_MODE'
71: FROM per_all_assignments_f paf,
72: per_periods_of_service pps,
73: per_assignment_status_types ast
74: WHERE paf.assignment_id = c_assignment_id
75: AND pps.period_of_service_id = paf.period_of_service_id
76: AND ast.assignment_status_type_id = paf.assignment_status_type_id
77: AND c_effective_date BETWEEN paf.effective_start_date