APPS.PER_CHANGE_PAY_ANALYTICS_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 38: FROM per_all_assignments_f paf, per_assignment_status_types past
34: )
35: IS
36: CURSOR ASSIGNMENTSID IS
37: SELECT paf.assignment_id 38: FROM per_all_assignments_f paf, per_assignment_status_types past 39: WHERE paf.primary_flag = 'Y'
40: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
41: AND paf.assignment_type IN ('E','C')
42: AND paf.assignment_status_type_id = past.assignment_status_type_id