APPS.PAY_GB_WNU_EDI dependencies on PAY_GB_EOY_ARCHIVE

Line 107: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,

103: l_stored_per_id number;
104: l_locking_act_id number;
105:
106: cursor csr_parameter_info is
107: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
108: 'PAYROLL_ID')) payroll_id,
109: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
110: 'TAX_REF'),1,20) tax_ref,
111: effective_date,

Line 109: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

105:
106: cursor csr_parameter_info is
107: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
108: 'PAYROLL_ID')) payroll_id,
109: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
110: 'TAX_REF'),1,20) tax_ref,
111: effective_date,
112: business_group_id
113: from pay_payroll_actions

Line 239: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,

235: l_wnu_id number;
236: l_ovn number;
237:
238: cursor csr_parameter_info is
239: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
240: 'PAYROLL_ID')) payroll_id,
241: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
242: 'TAX_REF'),1,20) tax_ref,
243: effective_date,

Line 241: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

237:
238: cursor csr_parameter_info is
239: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
240: 'PAYROLL_ID')) payroll_id,
241: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
242: 'TAX_REF'),1,20) tax_ref,
243: effective_date,
244: business_group_id
245: from pay_assignment_actions paa,