APPS.PAY_US_RSRW_UPGREV dependencies on PER_ASSIGNMENTS_F

Line 2875: FROM per_assignments_f paf

2871:
2872: CURSOR csr_get_asg_status(p_ctx_asg_id IN NUMBER
2873: ,p_prorate_end_dt IN DATE) IS
2874: SELECT past.per_system_status
2875: FROM per_assignments_f paf
2876: ,per_assignment_status_types past
2877: WHERE paf.assignment_id = p_ctx_asg_id
2878: AND paf.assignment_status_type_id = past.assignment_status_type_id
2879: AND p_prorate_end_dt between paf.effective_start_date and paf.effective_end_date;