APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on PAY_CORE_UTILS

Line 186: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year,

182: cursor archive_header is
183: select 'ASSIGNMENT_ACTION_ID=C',
184: pac.assignment_action_id,
185: 'BASIS_YEAR=P',
186: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year,
187: 'CREATION_DATE=P',
188: to_char(sysdate,'YYYYMMDD') creation_date
189: from pay_payroll_actions ppa,
190: pay_assignment_actions pac,

Line 210: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year,

206: pac.assignment_action_id,
207: 'TAX_UNIT_ID=C',
208: to_number(ac2.context) tax_unit_id,
209: 'BASIS_YEAR=P',
210: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year,
211: 'P_ASSIGNMENT_ACTION_ID=P',
212: to_char(pac.assignment_action_id),
213: 'PERSON_ID=P',
214: to_char(paa.person_id) person_id,

Line 239: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year

235: select distinct
236: 'TAX_UNIT_ID=C',
237: to_number(ac2.context) tax_unit_id,
238: 'BASIS_YEAR=P',
239: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year
240: from per_all_assignments_f paa,
241: pay_payroll_actions ppa,
242: pay_assignment_actions pac,
243: ff_archive_items fai,