APPS.PAY_IE_CESS_REPORT dependencies on PER_PERIODS_OF_SERVICE

Line 141: from per_periods_of_service ppos

137:
138: CURSOR cur_service_leave IS
139: select decode(ppos.leaving_reason, 'D','Y','N'),
140: ppos.actual_termination_date
141: from per_periods_of_service ppos
142: where ppos.person_id = p_person_id
143: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
144: from per_all_assignments_f paf,
145: pay_assignment_actions paa,

Line 371: per_periods_of_service pps

367: paf.assignment_number works_no,
368: pps.date_start hire_date
369: from per_assignments_f paf,
370: per_all_people_f ppf,
371: per_periods_of_service pps
372: where paf.person_id = ppf.person_id
373: and paf.assignment_id = cp_assignment_id
374: and cp_curr_eff_date between paf.effective_start_date
375: and paf.effective_end_date

Line 380: from per_periods_of_service pps1

376: and cp_curr_eff_date between ppf.effective_start_date
377: and ppf.effective_end_date
378: and pps.person_id = ppf.person_id
379: and pps.date_start = (select max(pps1.date_start)
380: from per_periods_of_service pps1
381: where pps1.person_id = paf.person_id
382: and pps1.date_start <= cp_curr_eff_date);
383:
384: c_employee_details_rec c_employee_details%ROWTYPE;

Line 1596: FROM --per_periods_of_service ppos,

1592: act.assignment_action_id run_action_id,
1593: act1.assignment_action_id prepaid_action_id,
1594: as1.assignment_number works_number,
1595: as1.period_of_service_id period_of_service_id
1596: FROM --per_periods_of_service ppos,
1597: per_all_assignments_f as1,
1598: pay_assignment_actions act,
1599: pay_payroll_actions appa,
1600: pay_action_interlocks pai,