DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 217: from per_all_assignments_f paa,

213: 'PERSON_ID=P',
214: to_char(paa.person_id) person_id,
215: 'ASSIGNMENT_NUMBER=P',
216: paa.assignment_number assignment_number
217: from per_all_assignments_f paa,
218: pay_payroll_actions ppa,
219: pay_assignment_actions pac,
220: ff_archive_items fai,
221: ff_archive_item_contexts ac2

Line 240: from per_all_assignments_f paa,

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,
244: ff_archive_item_contexts ac2