APPS.PAY_GB_RTI dependencies on PER_PERIODS_OF_SERVICE

Line 327: per_periods_of_service serv

323: cursor c_get_employee_flag(asg_id number) is
324: select distinct pap.effective_start_date , pap.effective_end_date , pap.current_employee_flag current_employee_flag
325: from per_all_assignments_f paa,
326: per_all_people_f pap,
327: per_periods_of_service serv
328: where paa.assignment_id = asg_id
329: and pap.person_id = paa.person_id
330: and paa.period_of_service_id = serv.period_of_service_id and
331: (serv.actual_termination_date is not null and serv.actual_termination_date+1 between pap.effective_start_date and pap.effective_end_date);

Line 354: per_periods_of_service serv,

350: serv.actual_termination_date actual_termination_date
351: FROM pay_assignment_actions act,
352: per_all_assignments_f paa,
353: per_all_people_f pap,
354: per_periods_of_service serv,
355: per_assignment_status_types past
356: where act.assignment_action_id = p_assactid
357: and act.assignment_id = paa.assignment_id
358: and paa.assignment_status_type_id = past.assignment_status_type_id

Line 387: per_periods_of_service serv,

383: serv.actual_termination_date actual_termination_date
384: FROM pay_assignment_actions act,
385: per_all_assignments_f paa,
386: per_all_people_f pap,
387: per_periods_of_service serv,
388: per_assignment_status_types past
389: where act.assignment_action_id = p_assactid
390: and act.assignment_id = paa.assignment_id
391: and paa.assignment_status_type_id = past.assignment_status_type_id

Line 1778: per_periods_of_service serv,

1774: pap.person_id person_id,past.per_system_status status
1775: from per_all_people_f pap,
1776: per_all_assignments_f asg,
1777: per_assignment_status_types past,
1778: per_periods_of_service serv,
1779: pay_all_payrolls_f pay,
1780: hr_soft_coding_keyflex sck
1781: where pap.person_id between stperson and endperson
1782: and pap.current_employee_flag = 'Y'

Line 1809: per_periods_of_service serv,

1805: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,
1806: pap.person_id person_id, serv.actual_termination_date actual_termination_date
1807: from per_all_people_f pap,
1808: per_all_assignments_f asg,
1809: per_periods_of_service serv,
1810: pay_all_payrolls_f pay,
1811: hr_soft_coding_keyflex sck
1812: where pap.person_id between stperson and endperson
1813: and serv.actual_termination_date is not null

Line 2065: per_periods_of_service serv,

2061: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,trim(pap.per_information10) per_agg_flag,
2062: pap.person_id person_id,asg.effective_start_date effective_start_date
2063: from per_all_people_f pap,
2064: per_all_assignments_f asg,
2065: per_periods_of_service serv,
2066: pay_all_payrolls_f pay,
2067: hr_soft_coding_keyflex sck,
2068: per_people_extra_info ppei
2069: where pap.person_id between stperson and endperson