DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on PAY_CA_EOY_RL2_AMEND_ARCH

Line 74: select to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(

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(

Line 76: 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(

Line 78: 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') ,

Line 80: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(

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,