[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
16-JUL-2002 ahanda 115.20 Changed insert_rows_thro_api_process
to insert data only if PL/SQL table
is populated.
15-AUG-2002 ahanda 115.21 Changed get_proposed_emp_salary for
performance.
27-SEP-2002 sodhingr 115.22 Changed get_personal_information
for GSCC compliance (removed default
clause)
01-NOV-2002 ahanda 115.23 Changed func get_defined_balance_id
to not error out if defbal not found
09-DEC-2002 joward 115.24 MLS enabled grade name
23-DEC-2002 joward 115.25 MLS enabled job name
12-Feb-2003 ekim 115.27 Made performance change to:
c_regular_salary,
c_hourly_salary for bug 2792737.
13-Mar-2003 ekim 115.28 Modified procedure
insert_rows_thro_api_process to
check for assignment_id of the
passing pl/sql table when inserting
create_action_information.
14-Mar-2003 ekim 115.29 2750949 Increased the precision of
ln_proposed_salary and
ln_pay_annualization_factor
to (20,5) from (17,2)
04-Apr-2003 ekim 115.30 2879910 Changed to ln_pay_basis_id from
lv_pay_basis to get pay basis in
if statement.
2879931 Added a cursor to get employer
phone number : lv_er_phone_number
19-JUL-2003 ahanda 115.31 Changed code to archive dates in
canonical format.
28-Jul-2003 vpandya 115.32 3053917 Added a parameter p_ytd_balcall_aaid
in to get_personal_information, and
added p_ppp_source_action_id and
p_ytd_balcall_aaid in to
get_employee_other_info. Changed
code in these procedures.
20-Jan-2004 vpandya 115.33 3379865 Changed get_employee_other_info:
if p_ytd_balcall_aaid is null, then
use p_run_action_id to get balance.
23-Jan-2004 rsethupa 115.34 3354127 11.5.10 Performance Changes
28-MAR-2004 ahanda 115.35 3536375 Net Pay distribution code was
assuming that not null source action
is sep check. This has been changed
to check for run type to take care
of Payment Method by Run Type.
16-APR-2004 rsethupa 115.36 3311866 US SS Payslip currency Format Enh.
Changed code to archive currency
data in canonical format for action
info categories 'EMPLOYEE DETAILS',
'EMPLOYEE NET PAY DISTRIBUTION' and
'EMPLOYEE ACCRUALS'.
12-AUG-2004 ahanda 115.37 3575803 Changed code to use data earned for
Pay Rate and Annualization factor.
20-MAY-2005 sodhingr 115.38 4225799 Archiving the value in canonical
format for EMPLOYEE OTHERS
INFORMATION
24-SEP-2005 rdhingra 115.39 4365487 Changed query in
cursor c_element_details in
procedure get_employee_other_info
28-SEP-2005 suman 115.40 4520091 Modified the cursor definition c_addr_line
in procedures get_employee_addr and
get_org_address(inside procedure
arch_pay_action_level_data)
15-OCT-2005 ahanda 115.41 4676875 Changed archiving for EMPLOYEE OTHERS
INFORMATION to be converted to
canonical if UOM is M or N.
Changed cursor c_element_details to
remove join for element links.
Backed out changes for bug 4520091.
24-APR-2006 pragupta 115.42 5182166 Added a new procedure
get_3rdparty_pay_distribution to
archive the Third Party Payments.
07-MAY-2006 ahanda 115.43 5209228 Added a new overloaded procedure -
- arch_pay_action_level_data
to be called from de-init code
11-MAY-2006 ahanda 115.44 4685928 Modifed get_3rdparty_pay_distribution
to store the correct action ID
02-OCT-2006 ahanda 115.45 Archiving accrual_code in action_info7
08-DEC-2006 ahanda 115.46 5692161 Changed get_employee_other_info to
archive values if <> 0
14-FEB-2006 kvsankar 115.47 5707497 Modified get_employee_other_info
to archive Unit Of Measure
05-JUL-2007 sausingh 115.48 5635335 Modified a condition in the cursor
c_net_pay in the procedure
get_net_pay_distribution to archive the bank details
of employer if the payment type is check .
31-MAR-2008 asgugupt 115.49 5585331 Replaced parameter p_curr_eff_date
with p_date_earned while opening c_employee_details
cursor in get_personal_information procedure
18-JUL-2008 mikarthi 115.51 7115367 While Archiving "EMPLOYEE OTHER INFORMATION" details
context at which the information was defined is
archived in to Action Info 13
03-DEC-2008 sudedas 115.52 7604041 Changed cursor c_salary_proposal
'Proposed Salary' displays correct
Figure in case NO proposals exist.
28-Mar-2009 skpatil 115.56 8305579 Modified cursor c_employee_details
to obtain assignment when orgnaization
is changed.
23-Oct-2009 sapalani 115.57 8827140 In function get_employee_other_info
added reporting_name column to the
cursors c_element_details and
c_defined_balance_id. Joined tl
tables to return values for reporting
_name based on correspondance langauge.
Added code to archive this extra value
in to ACTION_INFORMATION14.
26-Mar-2010 sapalani 115.58 9525602 In cusrors c_element_details and
c_defined_balance_id, Used nvl function
in where clause when comparing for
language.
14-Apr-2010 sjawid 115.59 9549403 Modified function get_shift to archive
Shift info for US localization.
14-Apr-2010 sjawid 115.60 9549403 Added new cursor get_shift_desc at get_shift
function to get description of shift code.
15-Apr-2010 sjawid 115.61 9549403 Modified cursor get_shift_desc such that
it will execute when get_shift_code cursor found.
09-Mar-2011 nkjaladi 115.62 10324741 Modified cursor c_employee_details of
pacakage procedure
pay_emp_action_arch.get_personal_information
to check for ex-employee based on
current_employee_flag instead of
person_type_id
30-Dec-2011 pkoduri 115.63 13529461 Added code to archive organization name and
phone number for all the organizations
for payslip requirement.
28-Mar-2012 sgotlasw 115.64 13815091 Modified condition in 'get_org_other_info'
by adding NVL so that Messages having NULL
values will get checked properly.
*******************************************************************/
/******************************************************************
** Package Local Variables
******************************************************************/
gv_package VARCHAR2(100);
select pdb.defined_balance_id
from pay_defined_balances pdb,
pay_balance_dimensions pbd
where pdb.balance_type_id = cp_balance_id
and pbd.database_item_suffix = cp_bal_dim
and pbd.balance_dimension_id = pdb.balance_dimension_id
and ((pbd.legislation_code = cp_legislation_code and
pbd.business_group_id is null)
or (pbd.legislation_code is null and
pbd.business_group_id is not null));
select 'x'
from pay_legislative_field_info
where field_name = 'MULTI_ASSIGNMENTS_FLAG'
and legislation_code = cp_legislation_code
and rule_mode = 'Y';
select multi_assignments_flag
from pay_payrolls_f
where payroll_id = cp_payroll_id
and cp_effective_date between effective_start_Date
and effective_end_date
and multi_assignments_flag = 'Y';
pay_emp_action_arch.lrr_act_tab.delete;
pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
pay_emp_action_arch.ltr_ppa_arch.delete;
Name : insert_rows_thro_api_process
Purpose :
Arguments :
Notes :
******************************************************************/
PROCEDURE insert_rows_thro_api_process(
p_action_context_id in number
,p_action_context_type in varchar2
,p_assignment_id in number
,p_tax_unit_id in number
,p_curr_pymt_eff_date in date
,p_tab_rec_data in pay_emp_action_arch.action_info_table
)
IS
l_action_information_id_1 NUMBER ;
lv_procedure_name := '.insert_rows_thro_api_process';
END insert_rows_thro_api_process;
select ppp.proposed_salary_n
from per_pay_proposals ppp
where ppp.assignment_id = cp_assignment_id
and ppp.change_date =
(select max(change_date)
from per_pay_proposals ppp1
where ppp1.assignment_id = cp_assignment_id
and ppp1.approved = 'Y'
/* Following modified for Bug# 7604041 */
/* and ppp1.change_date <= cp_date_earned */
and cp_date_earned between ppp1.change_date and NVL(ppp1.date_to, hr_general.END_OF_TIME())
);
select piv.element_type_id, piv.input_value_id
from pay_input_values_f piv,
per_pay_bases ppb
where ppb.pay_basis_id = cp_pay_basis_id
and ppb.input_value_id = piv.input_value_id
and cp_date_earned between piv.effective_start_date
and piv.effective_end_date;
select prrv.result_value
from pay_run_results prr,
pay_run_result_values prrv,
pay_input_values_f piv,
pay_assignment_actions paa,
pay_payroll_actions ppa
where prr.element_type_id + 0 = piv.element_type_id
and prr.run_result_id = prrv.run_result_id
and prr.source_type = 'E'
and piv.input_value_id = prrv.input_value_id
and piv.input_value_id = cp_input_value_id
and ppa.effective_date between piv.effective_start_date
and piv.effective_end_date
and paa.assignment_action_id = prr.assignment_action_id
and paa.assignment_id = cp_assignment_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.effective_date = cp_date_earned;
select prrv.result_value
from pay_run_results prr,
pay_run_result_values prrv,
pay_input_values_f piv,
pay_assignment_actions paa,
pay_payroll_actions ppa
where prr.element_type_id + 0 = piv.element_type_id
and prr.run_result_id = prrv.run_result_id
and prr.source_type = 'E'
and piv.input_value_id = prrv.input_value_id
and piv.element_type_id = cp_element_type_id
and piv.name = cp_input_value_name
and ppa.effective_date between piv.effective_start_date
and piv.effective_end_date
and paa.assignment_action_id = prr.assignment_action_id
and paa.assignment_id = cp_assignment_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.effective_date = cp_date_earned;
select ppb.pay_annualization_factor
from per_pay_bases ppb
where ppb.pay_basis_id = cp_pay_basis_id;
select ptpt.number_per_fiscal_year
from per_time_period_types ptpt
where ptpt.period_type = cp_period_type;
select org_information1, org_information2,
org_information3, org_information4,
org_information5, org_information6,
org_information7
from hr_organization_information
where org_information_context = cp_org_info_context
and organization_id = cp_organization_id;
select pet.element_name, peev.screen_entry_value,
piv.name, piv.uom,
nvl(petl.reporting_name,petl.element_name)
from pay_element_types_f pet,
pay_element_types_f_tl petl,
pay_element_entries_f pee,
pay_element_entry_values_f peev,
pay_input_values_f piv
where pet.element_type_id = cp_element_type_id
and pet.element_type_id = pee.element_type_id
and pee.assignment_id = cp_assignment_id
and pee.element_entry_id = peev.element_entry_id
and peev.input_value_id = cp_input_value_id
and piv.input_value_id = peev.input_value_id
and pet.element_type_id = petl.element_type_id
and petl.language = nvl(cp_language,userenv('LANG')) --Lang. cond. added for 8827140
and p_curr_pymt_eff_date between pet.effective_start_date
and pet.effective_end_date
and p_curr_pymt_eff_date between pee.effective_start_date
and pee.effective_end_date
and p_curr_pymt_eff_date between peev.effective_start_date
and peev.effective_end_date
and p_curr_pymt_eff_date between piv.effective_start_date
and piv.effective_end_date;
select pdb.defined_balance_id,
pbt.balance_name,
substr(pbd.database_item_suffix,2),
pbt.balance_uom,
nvl(pbtl.reporting_name,pbtl.balance_name)
from pay_defined_balances pdb,
pay_balance_dimensions pbd,
pay_balance_types pbt,
pay_balance_types_tl pbtl
where pbt.balance_type_id = cp_balance_type_id
and pbd.balance_dimension_id = cp_balance_dimension_id
and pbt.balance_type_id = pdb.balance_type_id
and pbd.balance_dimension_id = pdb.balance_dimension_id
and pbt.balance_type_id = pbtl.balance_type_id
and pbtl.language = nvl(cp_language,userenv('LANG')); --Lang. cond. added for 8827140
select name
from hr_organization_units
where organization_id = p_organization_id;
select location_code
from hr_locations_all
where location_id = cp_location_id;
select name
from per_jobs_vl
where job_id = cp_job_id
and date_from <= cp_effective_date
and nvl(date_to, cp_effective_date) >= cp_effective_date
order by date_from desc;
select name
from per_positions
where position_id = cp_position_id
and cp_effective_date between date_effective
and nvl(date_end,cp_effective_date) ;
select ppb.name
from per_pay_bases ppb,
pay_input_values_f piv
where ppb.pay_basis_id = cp_pay_basis_id
and piv.input_value_id = ppb.input_value_id
and p_effective_date between piv.effective_start_date
and piv.effective_end_date;
select meaning
from hr_lookups hl
where hl.lookup_type = 'FREQUENCY'
and hl.enabled_flag = 'Y'
and hl.lookup_code = cp_frequency
and cp_effective_date between nvl(hl.start_date_active, cp_effective_date)
and nvl(hl.end_date_active, cp_effective_date);
select name
from per_grades_vl
where grade_id = cp_grade_id
and date_from <= cp_effective_date
and nvl(date_to, cp_effective_date) >= cp_effective_date;
select meaning
from hr_lookups hl
where hl.lookup_type = 'BARGAINING_UNIT_CODE'
and hl.enabled_flag = 'Y'
and hl.lookup_code = cp_bargaining_unit
and cp_effective_date between nvl(hl.start_date_active, cp_effective_date)
and nvl(hl.end_date_active, cp_effective_date);
select name
from per_collective_agreements
where collective_agreement_id = cp_collective_agreement_id
and start_date <= cp_effective_date
and nvl(end_date, cp_effective_date) >= cp_effective_date;
select reference
from per_contracts
where contract_id = cp_contract_id
and p_effective_date between effective_start_date
and effective_end_date;
select hl.meaning
from hr_lookups hl
where hl.lookup_type='HOURLY_SALARIED_CODE'
and hl.lookup_code = cp_hourly_salaried_code
and hl.enabled_flag='Y'
and cp_effective_date between
nvl(hl.start_date_active, cp_effective_date) and
nvl(hl.end_date_active, cp_effective_date);
select segment5
from hr_soft_coding_keyflex
where soft_coding_keyflex_id = cp_soft_coding_keyflex_id;
select org_information9
from hr_organization_information
where org_information_context = 'Business Group Information'
and organization_id = cp_business_group_id;
select hl.meaning
from hr_lookups hl
where hl.lookup_type='US_SHIFTS'
and hl.lookup_code = cp_shift_code
and hl.enabled_flag='Y'
and hl.application_id = 800
and cp_effective_date between
nvl(hl.start_date_active,cp_effective_date)
and nvl(hl.end_date_active,cp_effective_date)
order by meaning;
select address_line1,
address_line2,
address_line3,
town_or_city,
region_1,
region_2,
region_3,
postal_code,
country
from per_addresses pa
where pa.person_id = cp_person_id
and pa.primary_flag = 'Y' --is address primary ?
and cp_effective_date between pa.date_from
and nvl(pa.date_to, cp_effective_date);
select pea.segment1 seg1,
pea.segment2 seg2,
pea.segment3 seg3,
pea.segment4 seg4,
pea.segment5 seg5,
pea.segment6 seg6,
pea.segment7 seg7,
pea.segment8 seg8,
pea.segment9 seg9,
pea.segment10 seg10,
ppp.value amount,
ppp.pre_payment_id,
popm.org_payment_method_id,
popm.org_payment_method_name,
pppm.personal_payment_method_id
from pay_assignment_actions paa,
pay_pre_payments ppp,
pay_org_payment_methods_f popm ,
pay_personal_payment_methods_f pppm,
pay_external_accounts pea
where paa.assignment_action_id = cp_pre_pay_action_id
and ppp.assignment_action_id = paa.assignment_action_id
and paa.assignment_id = cp_assignment_id
and ( ( ppp.source_action_id is null
and cp_ppp_source_action_id is null)
or
-- is it a Normal or Process Separate specific
-- Payments should be included in the Standard
-- SOE. Only Separate Payments should be in
-- a Separate SOE.
(ppp.source_action_id is not null
and cp_ppp_source_action_id is null
and exists (
select ''
from pay_run_types_f prt,
pay_assignment_actions paa_run,
pay_payroll_actions ppa_run
where paa_run.assignment_action_id
= ppp.source_action_id
and paa_run.payroll_action_id
= ppa_run.payroll_action_id
and paa_run.run_type_id = prt.run_type_id
and prt.run_method in ('P', 'N')
and ppa_run.effective_date
between prt.effective_start_date
and prt.effective_end_date
)
)
or
(cp_ppp_source_action_id is not null
and ppp.source_action_id = cp_ppp_source_action_id)
)
and ppp.org_payment_method_id = popm.org_payment_method_id
and popm.defined_balance_id is not null
and pppm.personal_payment_method_id(+)
= ppp.personal_payment_method_id
and pea.external_account_id = nvl(pppm.external_account_id,popm.external_account_id)
and cp_curr_pymt_eff_date between popm.effective_start_date
and popm.effective_end_date
and cp_curr_pymt_eff_date between nvl(pppm.effective_start_date,
cp_curr_pymt_eff_date)
and nvl(pppm.effective_end_date,
cp_curr_pymt_eff_date);
select paa.assignment_action_id
from pay_assignment_actions paa
where paa.source_action_id = cp_pre_pay_action_id
and paa.assignment_id = cp_assignment_id
and paa.action_status = 'C';
select pea.segment1 seg1,
pea.segment2 seg2,
pea.segment3 seg3,
pea.segment4 seg4,
pea.segment5 seg5,
pea.segment6 seg6,
pea.segment7 seg7,
pea.segment8 seg8,
pea.segment9 seg9,
pea.segment10 seg10,
ppp.value amount,
ppp.pre_payment_id,
popm.org_payment_method_id,
popm.org_payment_method_name,
pppm.personal_payment_method_id
from pay_assignment_actions paa,
pay_pre_payments ppp,
pay_org_payment_methods_f popm ,
pay_personal_payment_methods_f pppm,
pay_external_accounts pea
where paa.assignment_action_id = cp_pre_pay_action_id
and ppp.assignment_action_id = paa.assignment_action_id
and paa.assignment_id = cp_assignment_id
and ( ( ppp.source_action_id is null
and cp_ppp_source_action_id is null)
or
-- is it a Normal or Process Separate specific
-- Payments should be included in the Standard
-- SOE. Only Separate Payments should be in
-- a Separate SOE.
(ppp.source_action_id is not null
and cp_ppp_source_action_id is null
and exists (
select ''
from pay_run_types_f prt,
pay_assignment_actions paa_run,
pay_payroll_actions ppa_run
where paa_run.assignment_action_id
= ppp.source_action_id
and paa_run.payroll_action_id
= ppa_run.payroll_action_id
and paa_run.run_type_id = prt.run_type_id
and prt.run_method in ('P', 'N')
and ppa_run.effective_date
between prt.effective_start_date
and prt.effective_end_date
)
)
or
(cp_ppp_source_action_id is not null
and ppp.source_action_id = cp_ppp_source_action_id)
)
and ppp.org_payment_method_id = popm.org_payment_method_id
and popm.defined_balance_id is null
and pppm.personal_payment_method_id(+)
= ppp.personal_payment_method_id
and pea.external_account_id(+) = pppm.external_account_id
and cp_curr_pymt_eff_date between popm.effective_start_date
and popm.effective_end_date
and cp_curr_pymt_eff_date between nvl(pppm.effective_start_date,
cp_curr_pymt_eff_date)
and nvl(pppm.effective_end_date,
cp_curr_pymt_eff_date);
select hri.org_information1,
hri.org_information2, hri.org_information3,
hri.org_information4, hri.org_information5,
hri.org_information6, hri.org_information7,
org_information_context ----Bug 7115367
from hr_organization_information hri
where hri.organization_id = cp_organization_id
and hri.org_information_context = cp_org_information_context
and hri.org_information1 = 'MESG';
select address_line_1, address_line_2,
address_line_3, town_or_city,
region_1, region_2,
region_3, postal_code,
country, telephone_number_1
from hr_locations hl,
hr_organization_units hou
where hou.organization_id = cp_organization_id
and hou.location_id = hl.location_id;
select /*+ index(paf PER_ASSIGNMENTS_F_N7)*/
distinct paf.organization_id, -- Bug 3354127
paf.business_group_id
from per_all_assignments_f paf
where paf.payroll_id = cp_payroll_id
and cp_effective_date between paf.effective_start_date
and paf.effective_end_date;
insert_rows_thro_api_process(
p_action_context_id => p_payroll_action_id
,p_action_context_type => 'PA'
,p_assignment_id => null
,p_tax_unit_id => null
,p_curr_pymt_eff_date => p_effective_date
,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
);
select distinct
nvl(pai.tax_unit_id, -1)
,pai.action_information2 organization_id
from pay_action_information pai
,pay_assignment_actions paa
where pai.action_information_category = 'EMPLOYEE DETAILS'
and pai.action_context_type = 'AAP'
and pai.action_context_id = paa.assignment_action_id
and paa.payroll_Action_id = cp_payroll_action_id
and paa.action_status = 'C';
select ppa.business_group_id
from pay_payroll_actions ppa
where ppa.payroll_action_id = cp_payroll_action_id;
delete from pay_action_information pai
where pai.action_context_id = p_payroll_action_id
and pai.action_context_type = 'PA'
and pai.action_information_category in ('EMPLOYEE OTHER INFORMATION',
'ADDRESS DETAILS')
and (pai.action_information14 = 'Employer Address' or
pai.action_information2 = 'MESG');
insert_rows_thro_api_process(
p_action_context_id => p_payroll_action_id
,p_action_context_type => 'PA'
,p_assignment_id => null
,p_tax_unit_id => null
,p_curr_pymt_eff_date => p_effective_date
,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
);
select ppf.full_name,
ppf.national_identifier,
ppf.person_id,
pps.date_start,
ppf.employee_number,
ppf.original_date_of_hire,
pps.adjusted_svc_date,
paf.assignment_number,
paf.location_id,
paf.organization_id,
paf.job_id,
paf.position_id,
paf.pay_basis_id,
paf.frequency,
paf.grade_id,
paf.bargaining_unit_code,
paf.collective_agreement_id,
paf.contract_id,
paf.special_ceiling_step_id,
paf.people_group_id,
paf.normal_hours,
paf.time_normal_start,
paf.time_normal_finish,
paf.business_group_id,
paf.soft_coding_keyflex_id,
paf.hourly_salaried_code
from per_assignments_f paf,
per_all_people_f ppf,
per_all_people_f ppf1,
per_periods_of_service pps
where paf.person_id = ppf.person_id
and paf.assignment_id = cp_assignment_id
and ppf1.person_id = ppf.person_id /* 8305579 */
and (( --ppf1.person_type_id = 6 -- #10324741
ppf1.current_employee_flag = 'Y'
and cp_date_earned between paf.effective_start_date
and paf.effective_end_date)
or
( --ppf1.person_type_id <> 6 -- #10324741
ppf1.current_employee_flag <> 'Y'
and cp_curr_eff_date between paf.effective_start_date
and paf.effective_end_date))
and cp_date_earned between ppf.effective_start_date
and ppf.effective_end_date
and pps.person_id = ppf.person_id
and pps.date_start = (select max(pps1.date_start)
from per_periods_of_service pps1
where pps1.person_id = paf.person_id
and pps1.date_start <= cp_date_earned);
select payroll_id, period_type, start_date, cut_off_date
from per_time_periods
where time_period_id = cp_time_period_id;
select count(*)
from per_spinal_points psp,
per_spinal_points psp2,
per_spinal_point_steps_f psps,
per_spinal_point_steps_f psps2
where psps.step_id = cp_sp_ceil_step_id
and psp.spinal_point_id = psps.spinal_point_id
and psps.grade_spine_id = psps2.grade_spine_id
and psp2.spinal_point_id = psps2.spinal_point_id
and psp.sequence >= psp2.sequence
and cp_effective_date between psps.effective_start_date
and psps.effective_end_date
and cp_effective_date between psps2.effective_start_date
and psps2.effective_end_date
group by psp.spinal_point,
psps.step_id,
psps.sequence,
psps.effective_start_date,
psps.effective_end_date;
select telephone_number_1
from hr_locations hl,
hr_organization_units hou
where hou.organization_id = cp_organization_id
and hou.location_id = hl.location_id;
insert_rows_thro_api_process(
p_action_context_id => p_assactid
,p_action_context_type=> 'AAP'
,p_assignment_id => p_assignment_id
,p_tax_unit_id => p_tax_unit_id
,p_curr_pymt_eff_date => p_curr_pymt_eff_date
,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab
);