[Home] [Help]
701:
702:
703: sqlstr := 'select distinct person_id '
704: ||'from per_all_people_f ppf, '
705: ||'pay_payroll_actions ppa '
706: ||'where ppa.payroll_action_id = :payroll_action_id '
707: ||'and ppa.business_group_id = ppf.business_group_id '
708: ||'order by ppf.person_id';
709:
811: (pay_gb_eoy_archive.get_parameter(legislative_parameters,'EXCLUDE_QUAL')) exclude_qual,
812: (pay_gb_eoy_archive.get_parameter(legislative_parameters,'ASG_SET')) asg_set,
813: effective_date,
814: business_group_id
815: from pay_payroll_actions
816: where payroll_action_id = pactid;
817:
818:
819: cursor csr_asg (p_asg_set_id number)
1893: pay_run_results prr,
1894: pay_input_values_f piv,
1895: pay_run_result_values prrv,
1896: pay_assignment_actions assact,
1897: pay_payroll_actions pact,
1898: per_time_periods pptp
1899: where paf.assignment_id = p_assignment_id
1900: and paf.assignment_id = pee.assignment_id
1901: and pee.element_type_id = pexi.element_type_id
3901:
3902: cursor param_details is
3903: select upper((pay_gb_eoy_archive.get_parameter(legislative_parameters,'DATA_RETURN_TYPE'))) data_return_type,
3904: (pay_gb_eoy_archive.get_parameter(legislative_parameters,'ESTB_NUM')) estb_num
3905: from pay_payroll_actions ppa
3906: where ppa.payroll_action_id = p_payroll_action_id;
3907:
3908: param_details_rec param_details%rowtype;
3909:
3987: (pay_gb_eoy_archive.get_parameter(legislative_parameters,'EXCLUDE_ABS')) exclude_abs,
3988: (pay_gb_eoy_archive.get_parameter(legislative_parameters,'EXCLUDE_QUAL')) exclude_qual,
3989: business_group_id,
3990: ppa.payroll_action_id
3991: from pay_assignment_actions paa, pay_payroll_actions ppa
3992: where paa.assignment_action_id = p_assactid
3993: and paa.payroll_action_id = ppa.payroll_action_id;
3994:
3995: cursor csr_asg_no(p_census_day in date) is
4257: (pay_gb_eoy_archive.get_parameter(legislative_parameters,'EXCLUDE_QUAL')) exclude_qual,
4258: (pay_gb_eoy_archive.get_parameter(legislative_parameters,'ASG_SET')) asg_set,
4259: effective_date,
4260: business_group_id
4261: from pay_payroll_actions
4262: where payroll_action_id = pactid;
4263:
4264: cursor csr_asg is
4265: select distinct
4270: peo.employee_number emp_no,
4271: paf.assignment_number asg_no,
4272: peo.national_identifier ni_no,
4273: paa.assignment_action_id asg_act_id
4274: from pay_payroll_actions pay,
4275: pay_assignment_actions paa,
4276: per_all_assignments_f paf,
4277: per_all_people_f peo,
4278: (select max(effective_end_date) effective_date,assignment_id
4317: peo.employee_number emp_no,
4318: paf.assignment_number asg_no,
4319: peo.national_identifier ni_no,
4320: paa.assignment_action_id asg_act_id
4321: from pay_payroll_actions pay,
4322: pay_assignment_actions paa,
4323: per_all_assignments_f paf,
4324: per_all_people_f peo,
4325: (select max(effective_end_date) effective_date,assignment_id
4339:
4340: cursor fte_hrs is
4341: select action_information4 person_id,sum(action_information7)
4342: from pay_action_information pai,
4343: pay_payroll_actions ppa,
4344: pay_assignment_actions paa
4345: where ppa.payroll_action_id = pactid
4346: and ppa.payroll_action_id = paa.payroll_action_id
4347: and paa.assignment_action_id = pai.action_context_id
4365:
4366: CURSOR hdtr_count IS
4367: select COUNT(*)
4368: from pay_action_information pai,
4369: pay_payroll_actions ppa,
4370: pay_assignment_actions paa
4371: where ppa.payroll_action_id = pactid
4372: and ppa.payroll_action_id = paa.payroll_action_id
4373: and paa.assignment_action_id = pai.action_context_id
4382:
4383: cursor epsy_head_count_prm is
4384: select COUNT(*)
4385: from pay_action_information pai,
4386: pay_payroll_actions ppa,
4387: pay_assignment_actions paa
4388: where ppa.payroll_action_id = pactid
4389: and ppa.payroll_action_id = paa.payroll_action_id
4390: and paa.assignment_action_id = pai.action_context_id
4394:
4395: cursor epsy_head_count_part_time is
4396: select COUNT(*)
4397: from pay_action_information pai,
4398: pay_payroll_actions ppa,
4399: pay_assignment_actions paa
4400: where ppa.payroll_action_id = pactid
4401: and ppa.payroll_action_id = paa.payroll_action_id
4402: and paa.assignment_action_id = pai.action_context_id
4407: cursor epsy_fte_sum_part_time is
4408: select sum(pai2.action_information7)
4409: from pay_action_information pai,
4410: pay_action_information pai2,
4411: pay_payroll_actions ppa,
4412: pay_assignment_actions paa
4413: where ppa.payroll_action_id = pactid
4414: and ppa.payroll_action_id = paa.payroll_action_id
4415: and paa.assignment_action_id = pai.action_context_id