APPS.PER_ZA_WSP_XML_GEN_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 78: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

74: Arguments :
75: --------------------------------------------------------------------------*/
76: function preprocess_value
77: (
78: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
79: p_legislative_parameters in pay_payroll_actions.legislative_parameters%type
80: )
81: return varchar2 is
82:

Line 79: p_legislative_parameters in pay_payroll_actions.legislative_parameters%type

75: --------------------------------------------------------------------------*/
76: function preprocess_value
77: (
78: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
79: p_legislative_parameters in pay_payroll_actions.legislative_parameters%type
80: )
81: return varchar2 is
82:
83: l_preprocess_value varchar2(80);

Line 279: from pay_payroll_actions ppa

275:
276: -- changed action_context_type from PA to AAP
277: cursor csr_wsp_occ is
278: select pai.action_information6 occ_cat
279: from pay_payroll_actions ppa
280: , pay_assignment_actions paa
281: , pay_action_information pai
282: where ppa.payroll_action_id = p_payroll_action_id
283: AND paa.payroll_action_id = ppa.payroll_action_id

Line 295: from pay_payroll_actions ppa

291: select distinct pai.action_information3 person_id
292: , pai.action_information4 race
293: , pai.action_information5 sex
294: , pai.action_information7 disability
295: from pay_payroll_actions ppa
296: , pay_assignment_actions paa
297: , pay_action_information pai
298: where ppa.payroll_action_id = p_payroll_action_id
299: AND paa.payroll_action_id = ppa.payroll_action_id

Line 308: from pay_payroll_actions ppa

304: and pai.action_information6 = p_occ_cat;
305:
306: cursor csr_wsp_occ_sk_prs( p_occ_cat varchar) is
307: select distinct pai.action_information11 sk_pr_num
308: from pay_payroll_actions ppa
309: , pay_assignment_actions paa
310: , pay_action_information pai
311: where ppa.payroll_action_id = p_payroll_action_id
312: AND paa.payroll_action_id = ppa.payroll_action_id

Line 379: from pay_payroll_actions

375:
376: -- WSP year
377: select legislative_parameters
378: into l_leg_parameters
379: from pay_payroll_actions
380: where payroll_action_id = p_payroll_action_id;
381: --
382: l_wsp_end_year := to_number(per_za_wsp_archive_pkg.get_parameter('PLAN_YEAR',l_leg_parameters));
383:

Line 610: from pay_payroll_actions ppa

606: order by sk_num;
607:
608: cursor csr_atr_occ is
609: select action_information6 occ_cat
610: from pay_payroll_actions ppa
611: , pay_assignment_actions paa
612: , pay_action_information pai
613: where ppa.payroll_action_id = p_payroll_action_id
614: AND paa.payroll_action_id = ppa.payroll_action_id

Line 627: from pay_payroll_actions ppa

623: , action_information4 race
624: , action_information5 sex
625: , action_information7 disability
626: , action_information14 status
627: from pay_payroll_actions ppa
628: , pay_assignment_actions paa
629: , pay_action_information pai
630: where ppa.payroll_action_id = p_payroll_action_id
631: AND paa.payroll_action_id = ppa.payroll_action_id

Line 640: from pay_payroll_actions ppa

636: and pai.action_information6 = p_occ_cat;
637:
638: cursor csr_atr_occ_sk_prs( p_occ_cat varchar) is
639: select distinct action_information11 sk_pr_num
640: from pay_payroll_actions ppa
641: , pay_assignment_actions paa
642: , pay_action_information pai
643: where ppa.payroll_action_id = p_payroll_action_id
644: AND paa.payroll_action_id = ppa.payroll_action_id