APPS.PER_CHANGE_PAY_ANALYTICS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

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

Line 46: EMP_ASSIGNMENT_ID per_all_assignments_f.assignment_id%type;

42: AND paf.assignment_status_type_id = past.assignment_status_type_id
43: AND past.per_system_status <>'TERM_ASSIGN' ;
44:
45:
46: EMP_ASSIGNMENT_ID per_all_assignments_f.assignment_id%type;
47: l_check_var NUMBER;
48: table_name_var VARCHAR2(300);
49: PAYCHANGE sys_refcursor;
50:

Line 169: FROM PER_ALL_ASSIGNMENTS_F ASG ,

165: ELSE PGR.MID_VALUE*PPB.GRADE_ANNUALIZATION_FACTOR END
166:
167: GRADE_MID_VALUE ,
168: PET.INPUT_CURRENCY_CODE CURRENCY_CODE
169: FROM PER_ALL_ASSIGNMENTS_F ASG ,
170: (SELECT level-1 SUB_RELATIVE_LEVEL,
171: paf.assignment_id SUB_ASSIGNMENT_ID,
172: paf.person_id SUB_PERSON_ID,
173: paf.supervisor_id SUP_PERSON_ID,

Line 178: FROM per_all_assignments_f paf

174:
175: paf.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,
176:
177: paf.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
178: FROM per_all_assignments_f paf
179: WHERE paf.primary_flag = 'Y'
180: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND
181: paf.effective_end_date
182: AND paf.assignment_type IN ('E','C')