APPS.PAY_IN_PF_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 326: l_report PER_PERIODS_OF_SERVICE.PDS_INFORMATION1%TYPE;

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

Line 327: l_efile PER_PERIODS_OF_SERVICE.PDS_INFORMATION2%TYPE;

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

Line 344: per_periods_of_service pps,

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

Line 1428: per_periods_of_service pps,

1424: )
1425: UNION
1426: SELECT DISTINCT paa_init.assignment_id
1427: FROM pay_assignment_actions paa_init,
1428: per_periods_of_service pps,
1429: pay_payroll_actions ppa_init,
1430: per_assignments_f paf,
1431: hr_organization_information hoi
1432: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id