APPS.PAY_GB_WNU_EDI dependencies on PAY_GB_EOY_ARCHIVE

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

108: l_stored_per_id number;
109: l_locking_act_id number;
110:
111: cursor csr_parameter_info is
112: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
113: 'PAYROLL_ID')) payroll_id,
114: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
115: 'TAX_REF'),1,20) tax_ref,
116: effective_date,

Line 114: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

110:
111: cursor csr_parameter_info is
112: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
113: 'PAYROLL_ID')) payroll_id,
114: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
115: 'TAX_REF'),1,20) tax_ref,
116: effective_date,
117: business_group_id
118: from pay_payroll_actions

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

240: l_wnu_id number;
241: l_ovn number;
242:
243: cursor csr_parameter_info is
244: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
245: 'PAYROLL_ID')) payroll_id,
246: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
247: 'TAX_REF'),1,20) tax_ref,
248: effective_date,

Line 246: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

242:
243: cursor csr_parameter_info is
244: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
245: 'PAYROLL_ID')) payroll_id,
246: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
247: 'TAX_REF'),1,20) tax_ref,
248: effective_date,
249: business_group_id
250: from pay_assignment_actions paa,