70: Arguments :
71: --------------------------------------------------------------------------*/
72: function preprocess_value
73: (
74: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
75: p_legislative_parameters in pay_payroll_actions.legislative_parameters%type
76: )
77: return varchar2 is
78:
71: --------------------------------------------------------------------------*/
72: function preprocess_value
73: (
74: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
75: p_legislative_parameters in pay_payroll_actions.legislative_parameters%type
76: )
77: return varchar2 is
78:
79: l_preprocess_value varchar2(80);
268:
269: -- changed action_context_type from PA to AAP
270: cursor csr_wsp_occ is
271: select pai.action_information6 occ_cat
272: from pay_payroll_actions ppa
273: , pay_assignment_actions paa
274: , pay_action_information pai
275: where ppa.payroll_action_id = p_payroll_action_id
276: AND paa.payroll_action_id = ppa.payroll_action_id
284: select distinct pai.action_information3 person_id
285: , pai.action_information4 race
286: , pai.action_information5 sex
287: , pai.action_information7 disability
288: from pay_payroll_actions ppa
289: , pay_assignment_actions paa
290: , pay_action_information pai
291: where ppa.payroll_action_id = p_payroll_action_id
292: AND paa.payroll_action_id = ppa.payroll_action_id
297: and pai.action_information6 = p_occ_cat;
298:
299: cursor csr_wsp_occ_sk_prs( p_occ_cat varchar) is
300: select distinct pai.action_information11 sk_pr_num
301: from pay_payroll_actions ppa
302: , pay_assignment_actions paa
303: , pay_action_information pai
304: where ppa.payroll_action_id = p_payroll_action_id
305: AND paa.payroll_action_id = ppa.payroll_action_id
368:
369: -- WSP year
370: select legislative_parameters
371: into l_leg_parameters
372: from pay_payroll_actions
373: where payroll_action_id = p_payroll_action_id;
374: --
375: l_wsp_end_year := to_number(per_za_wsp_archive_pkg.get_parameter('PLAN_YEAR',l_leg_parameters));
376:
599: order by sk_num;
600:
601: cursor csr_atr_occ is
602: select action_information6 occ_cat
603: from pay_payroll_actions ppa
604: , pay_assignment_actions paa
605: , pay_action_information pai
606: where ppa.payroll_action_id = p_payroll_action_id
607: AND paa.payroll_action_id = ppa.payroll_action_id
616: , action_information4 race
617: , action_information5 sex
618: , action_information7 disability
619: , action_information14 status
620: from pay_payroll_actions ppa
621: , pay_assignment_actions paa
622: , pay_action_information pai
623: where ppa.payroll_action_id = p_payroll_action_id
624: AND paa.payroll_action_id = ppa.payroll_action_id
629: and pai.action_information6 = p_occ_cat;
630:
631: cursor csr_atr_occ_sk_prs( p_occ_cat varchar) is
632: select distinct action_information11 sk_pr_num
633: from pay_payroll_actions ppa
634: , pay_assignment_actions paa
635: , pay_action_information pai
636: where ppa.payroll_action_id = p_payroll_action_id
637: AND paa.payroll_action_id = ppa.payroll_action_id