APPS.PAY_IN_PF_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 328: l_report PER_PERIODS_OF_SERVICE.PDS_INFORMATION1%TYPE;

324: l_nssn PER_PEOPLE_F.PER_INFORMATION15%TYPE ;
325: l_hire_date DATE ;
326: l_emp_type VARCHAR2(2);
327: l_term_date DATE ;
328: l_report PER_PERIODS_OF_SERVICE.PDS_INFORMATION1%TYPE;
329: l_efile PER_PERIODS_OF_SERVICE.PDS_INFORMATION2%TYPE;
330: l_eps HR_SOFT_CODING_KEYFLEX.SEGMENT12%TYPE;
331: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
332:

Line 329: l_efile PER_PERIODS_OF_SERVICE.PDS_INFORMATION2%TYPE;

325: l_hire_date DATE ;
326: l_emp_type VARCHAR2(2);
327: l_term_date DATE ;
328: l_report PER_PERIODS_OF_SERVICE.PDS_INFORMATION1%TYPE;
329: l_efile PER_PERIODS_OF_SERVICE.PDS_INFORMATION2%TYPE;
330: l_eps HR_SOFT_CODING_KEYFLEX.SEGMENT12%TYPE;
331: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
332:
333: CURSOR csr_pf_people IS

Line 346: per_periods_of_service pps,

342: scl.segment12 eps -- EPS on higher employer wages
343: FROM per_people_f ppf,
344: per_person_types ppt,
345: per_assignments_f paf,
346: per_periods_of_service pps,
347: hr_soft_coding_keyflex scl
348: WHERE paf.person_id = ppf.person_id
349: AND paf.period_of_service_id = pps.period_of_service_id
350: AND ppf.person_type_id = ppt.person_type_id

Line 1432: per_periods_of_service pps,

1428: )
1429: UNION
1430: SELECT DISTINCT paa_init.assignment_id
1431: FROM pay_assignment_actions paa_init,
1432: per_periods_of_service pps,
1433: pay_payroll_actions ppa_init,
1434: per_assignments_f paf,
1435: hr_organization_information hoi
1436: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id