APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 1079: ,per_periods_of_service pps

1075: ,pap.date_of_birth date_of_birth
1076: ,pap.sex sex
1077: from per_all_assignments_f paa
1078: ,per_all_people_f pap
1079: ,per_periods_of_service pps
1080: where paa.assignment_id = '||p_assignment_id||'
1081: and paa.person_id = pap.person_id
1082: and pps.person_id = pap.person_id
1083: and paa.period_of_service_id = pps.period_of_service_id

Line 1174: FROM per_periods_of_service pps

1170: CURSOR csr_leave_reason(c_assignment_id NUMBER
1171: ,c_business_group_id NUMBER
1172: ,c_actual_termination_dt DATE ) IS
1173: SELECT leaving_reason
1174: FROM per_periods_of_service pps
1175: ,per_all_assignments_f paa
1176: WHERE paa.period_of_service_id = pps.period_of_service_id
1177: AND paa.assignment_id = c_assignment_id
1178: AND pps.business_group_id = c_business_group_id

Line 1229: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;

1225: l_active_rent_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1226: l_employee_category_ter VARCHAR2(30);
1227: l_collective_agreement_ter NUMBER;
1228: l_disability_degree_ter NUMBER;
1229: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
1230: l_leave_reason_code per_shared_types.information1%TYPE;
1231: --
1232: BEGIN
1233: OPEN csr_get_asg_values(p_assignment_id, p_effective_end_date);