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

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

Line 208: ff_archive_item_contexts ac3,

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

Line 250: ff_archive_item_contexts ac2,

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

Line 251: ff_archive_item_contexts ac3

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

Line 291: ff_archive_item_contexts ac2,

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

Line 292: ff_archive_item_contexts ac3

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

Line 331: ff_archive_item_contexts ac2,

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

Line 332: ff_archive_item_contexts ac3

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

Line 371: ff_archive_item_contexts ac2,

367: pay_assignment_actions mac,
368: pay_payroll_actions apa,
369: pay_assignment_actions aac,
370: ff_archive_items fai,
371: ff_archive_item_contexts ac2,
372: ff_archive_item_contexts ac3
373: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
374: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
375: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 372: ff_archive_item_contexts ac3

368: pay_payroll_actions apa,
369: pay_assignment_actions aac,
370: ff_archive_items fai,
371: ff_archive_item_contexts ac2,
372: ff_archive_item_contexts ac3
373: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
374: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
375: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
376: and apa.payroll_action_id = aac.payroll_action_id

Line 411: ff_archive_item_contexts ac2,

407: pay_assignment_actions mac,
408: pay_payroll_actions apa,
409: pay_assignment_actions aac,
410: ff_archive_items fai,
411: ff_archive_item_contexts ac2,
412: ff_archive_item_contexts ac3
413: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
414: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
415: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 412: ff_archive_item_contexts ac3

408: pay_payroll_actions apa,
409: pay_assignment_actions aac,
410: ff_archive_items fai,
411: ff_archive_item_contexts ac2,
412: ff_archive_item_contexts ac3
413: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
414: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
415: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
416: and apa.payroll_action_id = aac.payroll_action_id

Line 449: ff_archive_item_contexts ac2,

445: pay_assignment_actions mac,
446: pay_payroll_actions apa,
447: pay_assignment_actions aac,
448: ff_archive_items fai,
449: ff_archive_item_contexts ac2,
450: ff_archive_item_contexts ac3
451: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
452: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
453: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 450: ff_archive_item_contexts ac3

446: pay_payroll_actions apa,
447: pay_assignment_actions aac,
448: ff_archive_items fai,
449: ff_archive_item_contexts ac2,
450: ff_archive_item_contexts ac3
451: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
452: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
453: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
454: and apa.payroll_action_id = aac.payroll_action_id