APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PER_PERIODS_OF_SERVICE

Line 999: per_periods_of_service pps,

995: pap.sex,
996: pap.date_of_birth
997: FROM per_all_assignments_f paa,
998: per_all_people_f pap,
999: per_periods_of_service pps,
1000: pay_all_payrolls_f pay,
1001: hr_soft_coding_keyflex flex
1002: WHERE paa.person_id = pap.person_id
1003: AND pps.PERIOD_OF_SERVICE_ID(+) = paa.PERIOD_OF_SERVICE_ID

Line 1145: from per_periods_of_service pps,

1141:
1142: cursor csr_get_term_date (p_assignment_id Number)
1143: is
1144: select ACTUAL_TERMINATION_DATE
1145: from per_periods_of_service pps,
1146: per_assignments_f paf
1147: where paf.PERIOD_OF_SERVICE_ID = pps.PERIOD_OF_SERVICE_ID
1148: and paf.assignment_id =p_assignment_id;
1149:

Line 2657: per_periods_of_service pps

2653: cursor csr_ni is
2654: select ppf.national_identifier
2655: from per_assignments_f paf,
2656: per_all_people_f ppf,
2657: per_periods_of_service pps
2658: where ppf.person_id = paf.person_id
2659: and paf.assignment_id = p_assid
2660: and paf.period_of_service_id = pps.period_of_service_id(+)
2661: and p_eff_date between paf.effective_start_date and paf.effective_end_date

Line 4334: per_periods_of_service pos,

4330: from pay_payroll_actions pay,
4331: pay_assignment_actions paa,
4332: per_all_assignments_f paf,
4333: per_all_people_f pap,
4334: per_periods_of_service pos,
4335: pay_message_lines pml
4336: where pay.payroll_action_id = p_pact_id
4337: and paa.payroll_action_id = pay.payroll_action_id
4338: and pml.source_id = paa.assignment_action_id