APPS.PAY_GB_RTI_EAS dependencies on PER_PERIODS_OF_SERVICE

Line 271: per_periods_of_service serv

267: cursor c_get_employee_flag(asg_id number) is
268: select distinct pap.effective_start_date , pap.effective_end_date , pap.current_employee_flag current_employee_flag
269: from per_all_assignments_f paa,
270: per_all_people_f pap,
271: per_periods_of_service serv
272: where paa.assignment_id = asg_id
273: and pap.person_id = paa.person_id
274: and paa.period_of_service_id = serv.period_of_service_id and
275: (serv.actual_termination_date is not null and serv.actual_termination_date+1 between pap.effective_start_date and pap.effective_end_date);

Line 298: per_periods_of_service serv,

294: serv.actual_termination_date actual_termination_date
295: FROM pay_assignment_actions act,
296: per_all_assignments_f paa,
297: per_all_people_f pap,
298: per_periods_of_service serv,
299: per_assignment_status_types past
300: where act.assignment_action_id = p_assactid
301: and act.assignment_id = paa.assignment_id
302: and paa.assignment_status_type_id = past.assignment_status_type_id

Line 331: per_periods_of_service serv,

327: serv.actual_termination_date actual_termination_date
328: FROM pay_assignment_actions act,
329: per_all_assignments_f paa,
330: per_all_people_f pap,
331: per_periods_of_service serv,
332: per_assignment_status_types past
333: where act.assignment_action_id = p_assactid
334: and act.assignment_id = paa.assignment_id
335: and paa.assignment_status_type_id = past.assignment_status_type_id

Line 2392: per_periods_of_service serv,

2388: pap.person_id person_id,past.per_system_status status
2389: from per_all_people_f pap,
2390: per_all_assignments_f asg,
2391: per_assignment_status_types past,
2392: per_periods_of_service serv,
2393: pay_all_payrolls_f pay,
2394: hr_soft_coding_keyflex sck,
2395: hr_organization_information org
2396: where pap.person_id between stperson and endperson

Line 2431: per_periods_of_service serv,

2427: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,
2428: pap.person_id person_id, serv.actual_termination_date actual_termination_date
2429: from per_all_people_f pap,
2430: per_all_assignments_f asg,
2431: per_periods_of_service serv,
2432: pay_all_payrolls_f pay,
2433: hr_soft_coding_keyflex sck,
2434: hr_organization_information org
2435: where pap.person_id between stperson and endperson

Line 2715: per_periods_of_service serv,

2711: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,trim(pap.per_information10) per_agg_flag,
2712: pap.person_id person_id,asg.effective_start_date effective_start_date
2713: from per_all_people_f pap,
2714: per_all_assignments_f asg,
2715: per_periods_of_service serv,
2716: pay_all_payrolls_f pay,
2717: hr_soft_coding_keyflex sck,
2718: per_people_extra_info ppei
2719: where pap.person_id between stperson and endperson