268: from per_people_f people1
269: where people1.person_id = pap.person_id);
270: --
271: cursor month_year_action_sequence ( c_person_id per_all_people_f.person_id%type,
272: c_business_group_id hr_organization_units.business_group_id%type,
273: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
274: c_basis_year varchar2 )
275: is
276: select /*+ ORDERED USE_NL(pacmax) */
290: group by to_char(ppamax.effective_date,'MM')
291: order by to_char(ppamax.effective_date,'MM') desc;
292: --
293: cursor month_year_action ( c_person_id per_all_people_f.person_id%type,
294: c_business_group_id hr_organization_units.business_group_id%type,
295: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
296: c_basis_year varchar2,
297: c_action_sequence pay_assignment_actions.action_sequence%type )
298: is