APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1915: token_val pay_payroll_actions.legislative_parameters%type;

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

Line 1916: par_value pay_payroll_actions.legislative_parameters%type;

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

Line 2062: From pay_payroll_actions

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

Line 2067: from pay_payroll_actions ppa

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

Line 2076: From pay_payroll_actions

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

Line 2560: pay_payroll_actions ppa

2556: -----------------
2557: g_sql_range :=
2558: 'select distinct asg.person_id
2559: from per_assignments_f asg,
2560: pay_payroll_actions ppa
2561: where ppa.payroll_action_id = :payroll_action_id
2562: and asg.business_group_id = ppa.business_group_id
2563: and asg.assignment_type = ''E''
2564: order by asg.person_id';

Line 2604: , pay_payroll_actions ppa_arch

2600: , paa.assignment_id
2601: from per_all_people_f ppf
2602: , per_all_assignments_f paa
2603: , per_assignment_extra_info paei
2604: , pay_payroll_actions ppa_arch
2605: , per_periods_of_service pps
2606: where paa.business_group_id = g_bg_id
2607: and paa.person_id = ppf.person_id
2608: and ppf.person_id between p_stperson and p_endperson

Line 2653: From pay_payroll_actions

2649: ---
2650: -- set the global legislative parameters
2651: Select business_group_id
2652: Into g_bg_id -- Business Group Id
2653: From pay_payroll_actions
2654: Where payroll_action_id = pactid ;
2655:
2656: select ppa.legislative_parameters
2657: into l_leg_param

Line 2658: from pay_payroll_actions ppa

2654: Where payroll_action_id = pactid ;
2655:
2656: select ppa.legislative_parameters
2657: into l_leg_param
2658: from pay_payroll_actions ppa
2659: where payroll_action_id = pactid;
2660:
2661: l_tmp_char := get_parameter('PLAN_YEAR', l_leg_param);
2662: l_legal_entity_id := get_parameter('LEGAL_ENTITY_ID', l_leg_param);

Line 2667: From pay_payroll_actions

2663:
2664: -- Get the effective date of the payroll action
2665: Select effective_date
2666: Into g_archive_effective_date
2667: From pay_payroll_actions
2668: Where payroll_action_id = pactid;
2669:
2670: -- get_parameters(pactid, 'LEGAL_ENTITY_ID', l_tmp_char);
2671: if (l_legal_entity_id is null) then

Line 2794: From pay_payroll_actions

2790:
2791: -- set the global legislative parameters
2792: Select business_group_id
2793: Into g_bg_id -- Business Group Id
2794: From pay_payroll_actions
2795: Where payroll_action_id = pactid ;
2796:
2797: select ppa.legislative_parameters
2798: into l_leg_param

Line 2799: from pay_payroll_actions ppa

2795: Where payroll_action_id = pactid ;
2796:
2797: select ppa.legislative_parameters
2798: into l_leg_param
2799: from pay_payroll_actions ppa
2800: where payroll_action_id = pactid;
2801:
2802: l_tmp_char := get_parameter('PLAN_YEAR', l_leg_param);
2803: l_legal_entity_id := get_parameter('LEGAL_ENTITY_ID', l_leg_param);

Line 2808: From pay_payroll_actions

2804:
2805: -- Get the effective date of the payroll action
2806: Select effective_date
2807: Into g_archive_effective_date
2808: From pay_payroll_actions
2809: Where payroll_action_id = pactid;
2810:
2811: -- get_parameters(pactid, 'LEGAL_ENTITY_ID', l_tmp_char);
2812: if (l_legal_entity_id is null) then