[Home] [Help]
868: /* Variables used to hold the current values returned within the loop for
869: checking against the new values returned from within the loop on the
870: next iteration. */
871:
872: l_prev_person_id per_all_people_f.person_id%type;
873: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
874:
875: /* Variable to hold the jurisdiction code used as a context for state
876: reporting. */
998: cp_period_end date) IS
999: select paa.assignment_action_id
1000: from pay_assignment_actions paa,
1001: per_all_assignments_f paf,
1002: per_all_people_f ppf,
1003: pay_payroll_actions ppa,
1004: pay_action_classifications pac
1005: where ppf.person_id = cp_person_id
1006: and paf.person_id = ppf.person_id
2009: PEOPLE.date_of_birth,
2010: replace(PEOPLE.national_identifier,' '),
2011: PEOPLE.pre_name_adjunct
2012: from per_all_assignments_f ASSIGN
2013: ,per_all_people_f PEOPLE
2014: where ASSIGN.assignment_id = cp_asg_id
2015: and PEOPLE.person_id = ASSIGN.person_id
2016: and PEOPLE.effective_end_date =
2017: (select max(effective_end_date)
2014: where ASSIGN.assignment_id = cp_asg_id
2015: and PEOPLE.person_id = ASSIGN.person_id
2016: and PEOPLE.effective_end_date =
2017: (select max(effective_end_date)
2018: from per_all_people_f PEOPLE1
2019: where PEOPLE1.person_id = PEOPLE.person_id);
2020:
2021:
2022: /* Query to get the max asg_act_id for a payroll run in a given year
2028: cp_period_end date) IS
2029: select paa.assignment_action_id
2030: from pay_assignment_actions paa,
2031: per_all_assignments_f paf,
2032: per_all_people_f ppf,
2033: pay_payroll_actions ppa,
2034: pay_action_classifications pac,
2035: pay_action_contexts pac1,
2036: ff_contexts fc
2938: select ppf.full_name,
2939: replace(ppf.national_identifier,' ')
2940: into l_beneficiary_name,
2941: l_beneficiary_sin
2942: from per_all_people_f ppf
2943: where ppf.person_id = to_number(l_per_eit_beneficiary_id);
2944:
2945: exception when no_data_found then
2946: l_beneficiary_name := null;