APPS.PAY_SG_IRAS_ARCHIVE dependencies on PAY_CORE_UTILS

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

340: cursor archive_header is
341: select 'ASSIGNMENT_ACTION_ID=C',
342: pac.assignment_action_id,
343: 'BASIS_YEAR=P',
344: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year,
345: 'CREATION_DATE=P',
346: to_char(sysdate,'YYYYMMDD') creation_date
347: from pay_payroll_actions ppa,
348: pay_assignment_actions pac,

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

364: pac.assignment_action_id,
365: 'TAX_UNIT_ID=C',
366: to_number(ac2.context) tax_unit_id,
367: 'BASIS_YEAR=P',
368: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year,
369: 'P_ASSIGNMENT_ACTION_ID=P',
370: to_char(pac.assignment_action_id),
371: 'PERSON_ID=P',
372: to_char(paa.person_id) person_id,

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

393: select distinct
394: 'TAX_UNIT_ID=C',
395: to_number(ac2.context) tax_unit_id,
396: 'BASIS_YEAR=P',
397: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year
398: from per_all_assignments_f paa,
399: pay_payroll_actions ppa,
400: pay_assignment_actions pac,
401: ff_archive_items fai,