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.

[Home] [Help]

APPS.PAY_SG_IRAS_MAGTAPE dependencies on PAY_MAGTAPE_GENERIC

Line 57: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

53: pay_payroll_actions apa,
54: pay_assignment_actions aac,
55: ff_archive_items ffi,
56: ff_database_items fdi
57: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
58: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
59: and apa.payroll_action_id = aac.payroll_action_id
60: and apa.action_status = 'C'
61: and ffi.context1 = aac.assignment_action_id /* Added joins for bug:3232300 */

Line 81: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

77: pay_payroll_actions apa,
78: pay_assignment_actions aac
79: ,ff_archive_items ffi
80: ,ff_database_items fdi
81: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
82: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
83: and apa.payroll_action_id = aac.payroll_action_id
84: and apa.action_status = 'C'
85: and ffi.context1 = aac.assignment_action_id /* Added joins for bug:3232300 */

Line 105: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

101: pay_payroll_actions apa,
102: pay_assignment_actions aac,
103: ff_archive_items ffi,
104: ff_database_items fdi
105: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
106: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
107: and apa.payroll_action_id = aac.payroll_action_id
108: and apa.action_status = 'C'
109: and ffi.context1 = aac.assignment_action_id /* Added joins for bug:3232300 */

Line 129: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

125: pay_payroll_actions apa,
126: pay_assignment_actions aac,
127: ff_archive_items ffi,
128: ff_database_items fdi
129: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
130: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
131: and apa.payroll_action_id = aac.payroll_action_id
132: and apa.action_status = 'C'
133: and ffi.context1 = aac.assignment_action_id /* Added joins for bug:3232300 */

Line 170: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

166: pay_payroll_actions mpa,
167: pay_assignment_actions mac,
168: pay_payroll_actions apa,
169: pay_assignment_actions aac
170: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
171: and mpa.payroll_action_id = mac.payroll_action_id
172: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
173: and apa.payroll_action_id = aac.payroll_action_id
174: and paa.assignment_id = aac.assignment_id

Line 211: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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')
213: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
214: and apa.payroll_action_id = aac.payroll_action_id
215: and paa.assignment_id = aac.assignment_id

Line 212: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

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')
213: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
214: and apa.payroll_action_id = aac.payroll_action_id
215: and paa.assignment_id = aac.assignment_id
216: and aac.assignment_action_id = fai.context1

Line 252: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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
256: and aac.assignment_id = paa.assignment_id

Line 253: and paa.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')

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
256: and aac.assignment_id = paa.assignment_id
257: and aac.assignment_action_id = fai.context1

Line 293: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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
297: and paa.assignment_id = aac.assignment_id

Line 294: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

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
297: and paa.assignment_id = aac.assignment_id
298: and apa.action_status = 'C'

Line 333: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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
337: and paa.assignment_id = aac.assignment_id

Line 334: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

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
337: and paa.assignment_id = aac.assignment_id
338: and apa.action_status = 'C'

Line 373: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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
377: and paa.assignment_id = aac.assignment_id

Line 374: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

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
377: and paa.assignment_id = aac.assignment_id
378: and apa.action_status = 'C'

Line 413: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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
417: and paa.assignment_id = aac.assignment_id

Line 414: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

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
417: and paa.assignment_id = aac.assignment_id
418: and apa.action_status = 'C'

Line 451: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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
455: and paa.assignment_id = aac.assignment_id

Line 452: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

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
455: and paa.assignment_id = aac.assignment_id
456: and apa.action_status = 'C'