APPS.PAY_IE_P45_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 1967: from per_periods_of_service ppos

1963:
1964: CURSOR cur_service_leave IS
1965: select decode(ppos.leaving_reason, 'D','Y','N'),
1966: ppos.actual_termination_date
1967: from per_periods_of_service ppos
1968: where ppos.person_id = p_person_id
1969: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
1970: from per_all_assignments_f paf,
1971: pay_assignment_actions paa,

Line 2141: from per_periods_of_service ppos

2137: --
2138: CURSOR cur_service_leave IS
2139: select decode(ppos.leaving_reason, 'D','Y','N'),
2140: ppos.actual_termination_date
2141: from per_periods_of_service ppos
2142: where ppos.person_id = p_person_id
2143: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
2144: from per_all_assignments_f paf,
2145: pay_assignment_actions paa,

Line 2155: FROM per_periods_of_service ppos,

2151: );
2152: /*
2153: SELECT decode(ppos.leaving_reason, 'D','Y','N'),
2154: ppos.actual_termination_date
2155: FROM per_periods_of_service ppos,
2156: per_all_assignments_f paf
2157: WHERE paf.assignment_id = p_assignment_id
2158: AND ppos.period_of_service_id = paf.period_of_service_id;
2159: */

Line 2931: FROM --per_periods_of_service ppos,

2927: act.assignment_action_id run_action_id,
2928: act1.assignment_action_id prepaid_action_id,
2929: as1.assignment_number works_number,
2930: as1.period_of_service_id period_of_service_id
2931: FROM --per_periods_of_service ppos,
2932: per_all_assignments_f as1,
2933: pay_assignment_actions act,
2934: pay_payroll_actions appa,
2935: pay_action_interlocks pai,