APPS.PAY_IE_P45_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 2634: from per_periods_of_service ppos

2630:
2631: CURSOR cur_service_leave IS
2632: select decode(ppos.leaving_reason, 'D','Y','N'),
2633: ppos.actual_termination_date
2634: from per_periods_of_service ppos
2635: where ppos.person_id = p_person_id
2636: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
2637: from per_all_assignments_f paf,
2638: pay_assignment_actions paa,

Line 2808: from per_periods_of_service ppos

2804: --
2805: CURSOR cur_service_leave IS
2806: select decode(ppos.leaving_reason, 'D','Y','N'),
2807: ppos.actual_termination_date
2808: from per_periods_of_service ppos
2809: where ppos.person_id = p_person_id
2810: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
2811: from per_all_assignments_f paf,
2812: pay_assignment_actions paa,

Line 2822: FROM per_periods_of_service ppos,

2818: );
2819: /*
2820: SELECT decode(ppos.leaving_reason, 'D','Y','N'),
2821: ppos.actual_termination_date
2822: FROM per_periods_of_service ppos,
2823: per_all_assignments_f paf
2824: WHERE paf.assignment_id = p_assignment_id
2825: AND ppos.period_of_service_id = paf.period_of_service_id;
2826: */

Line 3639: FROM --per_periods_of_service ppos,

3635: act.assignment_action_id run_action_id,
3636: act1.assignment_action_id prepaid_action_id,
3637: as1.assignment_number works_number,
3638: as1.period_of_service_id period_of_service_id
3639: FROM --per_periods_of_service ppos,
3640: per_all_assignments_f as1,
3641: pay_assignment_actions act,
3642: pay_payroll_actions appa,
3643: pay_action_interlocks pai,

Line 4785: from per_periods_of_service ppos

4781: /* 7291676 */
4782: /* to check whether the termination date of the assignment is after 2009 */
4783: CURSOR cur_service_leave_year(c_person_id per_all_people_f.person_id%type,c_action_context_id pay_assignment_actions.assignment_action_id%type) IS
4784: select 'Y'
4785: from per_periods_of_service ppos
4786: where ppos.person_id = c_person_id
4787: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
4788: from per_all_assignments_f paf,
4789: pay_assignment_actions paa,