70: ,p_asg_set out nocopy number
71: ,p_year out nocopy varchar2)
72: IS
73: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
74: select to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
75: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
76: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
77: 'PER_ID',ppa.legislative_parameters)),
78: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
72: IS
73: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
74: select to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
75: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
76: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
77: 'PER_ID',ppa.legislative_parameters)),
78: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
79: 'SSN',ppa.legislative_parameters)),
80: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
74: select to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
75: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
76: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
77: 'PER_ID',ppa.legislative_parameters)),
78: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
79: 'SSN',ppa.legislative_parameters)),
80: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
81: 'ASG_SET',ppa.legislative_parameters)),
82: to_char(effective_date,'YYYY') ,
76: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
77: 'PER_ID',ppa.legislative_parameters)),
78: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
79: 'SSN',ppa.legislative_parameters)),
80: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
81: 'ASG_SET',ppa.legislative_parameters)),
82: to_char(effective_date,'YYYY') ,
83: effective_date,
84: start_date,