APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PER_PERIODS_OF_SERVICE

Line 998: per_periods_of_service pps,

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

Line 1144: from per_periods_of_service pps,

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

Line 2591: per_periods_of_service pps

2587: cursor csr_ni is
2588: select ppf.national_identifier
2589: from per_assignments_f paf,
2590: per_all_people_f ppf,
2591: per_periods_of_service pps
2592: where ppf.person_id = paf.person_id
2593: and paf.assignment_id = p_assid
2594: and paf.period_of_service_id = pps.period_of_service_id(+)
2595: and p_eff_date between paf.effective_start_date and paf.effective_end_date

Line 4214: per_periods_of_service pos,

4210: from pay_payroll_actions pay,
4211: pay_assignment_actions paa,
4212: per_all_assignments_f paf,
4213: per_all_people_f pap,
4214: per_periods_of_service pos,
4215: pay_message_lines pml
4216: where pay.payroll_action_id = p_pact_id
4217: and paa.payroll_action_id = pay.payroll_action_id
4218: and pml.source_id = paa.assignment_action_id