DBA Data[Home] [Help]

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