244: PROCEDURE archive_code (p_assactid in number,
245: p_effective_date in date) IS
246:
247:
248: l_person_id per_all_people_f.person_id%TYPE;
249: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
250: l_end_date DATE;
251:
252: BEGIN
356: ,decode(hr.segment2,'Y','Yes','No') railway_benefit
357: ,hoi.organization_id organization_id
358: ,hoi.org_information1 company_name
359: ,paas.payroll_action_id
360: FROM per_all_people_F pap
361: ,per_periods_of_service ppf
362: ,per_all_assignments_f paa
363: ,pay_assignment_actions paas
364: ,hr_soft_coding_keyflex hr