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