APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1914: token_val pay_payroll_actions.legislative_parameters%type;

1910: ) return varchar2 is
1911:
1912: start_ptr number;
1913: end_ptr number;
1914: token_val pay_payroll_actions.legislative_parameters%type;
1915: par_value pay_payroll_actions.legislative_parameters%type;
1916: l_proc constant varchar2(60) := g_package || 'get_parameter';
1917:
1918: begin

Line 1915: par_value pay_payroll_actions.legislative_parameters%type;

1911:
1912: start_ptr number;
1913: end_ptr number;
1914: token_val pay_payroll_actions.legislative_parameters%type;
1915: par_value pay_payroll_actions.legislative_parameters%type;
1916: l_proc constant varchar2(60) := g_package || 'get_parameter';
1917:
1918: begin
1919: hr_utility.trace('Entering '|| l_proc);

Line 2060: From pay_payroll_actions

2056: --
2057: -- set the global legislative parameters
2058: Select business_group_id
2059: Into g_bg_id -- Business Group Id
2060: From pay_payroll_actions
2061: Where payroll_action_id = pactid ;
2062:
2063: select ppa.legislative_parameters
2064: into l_leg_param

Line 2065: from pay_payroll_actions ppa

2061: Where payroll_action_id = pactid ;
2062:
2063: select ppa.legislative_parameters
2064: into l_leg_param
2065: from pay_payroll_actions ppa
2066: where payroll_action_id = pactid;
2067:
2068: l_tmp_char := get_parameter('PLAN_YEAR', l_leg_param);
2069: l_legal_entity_id := get_parameter('LEGAL_ENTITY_ID', l_leg_param);

Line 2074: From pay_payroll_actions

2070:
2071: -- Get the effective date of the payroll action
2072: Select effective_date
2073: Into g_archive_effective_date
2074: From pay_payroll_actions
2075: Where payroll_action_id = pactid;
2076:
2077: -- get_parameters(pactid, 'LEGAL_ENTITY_ID', l_tmp_char);
2078: if (l_legal_entity_id is null) then

Line 2554: pay_payroll_actions ppa

2550: -----------------
2551: g_sql_range :=
2552: 'select distinct asg.person_id
2553: from per_assignments_f asg,
2554: pay_payroll_actions ppa
2555: where ppa.payroll_action_id = :payroll_action_id
2556: and asg.business_group_id = ppa.business_group_id
2557: and asg.assignment_type = ''E''
2558: order by asg.person_id';

Line 2598: , pay_payroll_actions ppa_arch

2594: , paa.assignment_id
2595: from per_all_people_f ppf
2596: , per_all_assignments_f paa
2597: , per_assignment_extra_info paei
2598: , pay_payroll_actions ppa_arch
2599: , per_periods_of_service pps
2600: where paa.business_group_id = g_bg_id
2601: and paa.person_id = ppf.person_id
2602: and ppf.person_id between p_stperson and p_endperson

Line 2647: From pay_payroll_actions

2643: ---
2644: -- set the global legislative parameters
2645: Select business_group_id
2646: Into g_bg_id -- Business Group Id
2647: From pay_payroll_actions
2648: Where payroll_action_id = pactid ;
2649:
2650: select ppa.legislative_parameters
2651: into l_leg_param

Line 2652: from pay_payroll_actions ppa

2648: Where payroll_action_id = pactid ;
2649:
2650: select ppa.legislative_parameters
2651: into l_leg_param
2652: from pay_payroll_actions ppa
2653: where payroll_action_id = pactid;
2654:
2655: l_tmp_char := get_parameter('PLAN_YEAR', l_leg_param);
2656: l_legal_entity_id := get_parameter('LEGAL_ENTITY_ID', l_leg_param);

Line 2661: From pay_payroll_actions

2657:
2658: -- Get the effective date of the payroll action
2659: Select effective_date
2660: Into g_archive_effective_date
2661: From pay_payroll_actions
2662: Where payroll_action_id = pactid;
2663:
2664: -- get_parameters(pactid, 'LEGAL_ENTITY_ID', l_tmp_char);
2665: if (l_legal_entity_id is null) then

Line 2788: From pay_payroll_actions

2784:
2785: -- set the global legislative parameters
2786: Select business_group_id
2787: Into g_bg_id -- Business Group Id
2788: From pay_payroll_actions
2789: Where payroll_action_id = pactid ;
2790:
2791: select ppa.legislative_parameters
2792: into l_leg_param

Line 2793: from pay_payroll_actions ppa

2789: Where payroll_action_id = pactid ;
2790:
2791: select ppa.legislative_parameters
2792: into l_leg_param
2793: from pay_payroll_actions ppa
2794: where payroll_action_id = pactid;
2795:
2796: l_tmp_char := get_parameter('PLAN_YEAR', l_leg_param);
2797: l_legal_entity_id := get_parameter('LEGAL_ENTITY_ID', l_leg_param);

Line 2802: From pay_payroll_actions

2798:
2799: -- Get the effective date of the payroll action
2800: Select effective_date
2801: Into g_archive_effective_date
2802: From pay_payroll_actions
2803: Where payroll_action_id = pactid;
2804:
2805: -- get_parameters(pactid, 'LEGAL_ENTITY_ID', l_tmp_char);
2806: if (l_legal_entity_id is null) then