eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_IRAS_MAGTAPE dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 205: ff_archive_item_contexts ac2,

201: pay_payroll_actions apa,
202: pay_assignment_actions aac,
203: pay_payroll_actions mpa,
204: ff_archive_items fai,
205: ff_archive_item_contexts ac2,
206: ff_archive_item_contexts ac3,
207: ff_user_entities ffe,
208: ff_routes ffr
209: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 206: ff_archive_item_contexts ac3,

202: pay_assignment_actions aac,
203: pay_payroll_actions mpa,
204: ff_archive_items fai,
205: ff_archive_item_contexts ac2,
206: ff_archive_item_contexts ac3,
207: ff_user_entities ffe,
208: ff_routes ffr
209: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
210: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

Line 248: ff_archive_item_contexts ac2,

244: per_all_assignments_f paa,
245: ff_archive_items fai,
246: ff_archive_items fai1,
247: ff_database_items fdi,
248: ff_archive_item_contexts ac2,
249: ff_archive_item_contexts ac3
250: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
251: and paa.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')
252: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 249: ff_archive_item_contexts ac3

245: ff_archive_items fai,
246: ff_archive_items fai1,
247: ff_database_items fdi,
248: ff_archive_item_contexts ac2,
249: ff_archive_item_contexts ac3
250: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
251: and paa.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')
252: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
253: and apa.payroll_action_id = aac.payroll_action_id

Line 290: ff_archive_item_contexts ac2,

286: pay_assignment_actions mac,
287: pay_payroll_actions apa,
288: pay_assignment_actions aac,
289: ff_archive_items fai,
290: ff_archive_item_contexts ac2,
291: ff_archive_item_contexts ac3
292: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
293: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
294: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 291: ff_archive_item_contexts ac3

287: pay_payroll_actions apa,
288: pay_assignment_actions aac,
289: ff_archive_items fai,
290: ff_archive_item_contexts ac2,
291: ff_archive_item_contexts ac3
292: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
293: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
294: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
295: and apa.payroll_action_id = aac.payroll_action_id

Line 334: ff_archive_item_contexts ac2,

330: pay_assignment_actions mac,
331: pay_payroll_actions apa,
332: pay_assignment_actions aac,
333: ff_archive_items fai,
334: ff_archive_item_contexts ac2,
335: ff_archive_item_contexts ac3
336: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
337: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
338: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 335: ff_archive_item_contexts ac3

331: pay_payroll_actions apa,
332: pay_assignment_actions aac,
333: ff_archive_items fai,
334: ff_archive_item_contexts ac2,
335: ff_archive_item_contexts ac3
336: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
337: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
338: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
339: and apa.payroll_action_id = aac.payroll_action_id

Line 378: ff_archive_item_contexts ac2,

374: pay_assignment_actions mac,
375: pay_payroll_actions apa,
376: pay_assignment_actions aac,
377: ff_archive_items fai,
378: ff_archive_item_contexts ac2,
379: ff_archive_item_contexts ac3
380: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
381: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
382: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 379: ff_archive_item_contexts ac3

375: pay_payroll_actions apa,
376: pay_assignment_actions aac,
377: ff_archive_items fai,
378: ff_archive_item_contexts ac2,
379: ff_archive_item_contexts ac3
380: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
381: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
382: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
383: and apa.payroll_action_id = aac.payroll_action_id

Line 418: ff_archive_item_contexts ac2,

414: pay_assignment_actions mac,
415: pay_payroll_actions apa,
416: pay_assignment_actions aac,
417: ff_archive_items fai,
418: ff_archive_item_contexts ac2,
419: ff_archive_item_contexts ac3
420: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
421: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
422: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 419: ff_archive_item_contexts ac3

415: pay_payroll_actions apa,
416: pay_assignment_actions aac,
417: ff_archive_items fai,
418: ff_archive_item_contexts ac2,
419: ff_archive_item_contexts ac3
420: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
421: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
422: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
423: and apa.payroll_action_id = aac.payroll_action_id