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 PAY_MAGTAPE_GENERIC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
296: and paa.person_id = ppei.person_id -- and paa.assignment_id = paei.assignment_id /* Bug 2691877 */

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

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
296: and paa.person_id = ppei.person_id -- and paa.assignment_id = paei.assignment_id /* Bug 2691877 */
297: and ac3.context = ppei.person_extra_info_id -- and ac3.context = paei.assignment_extra_info_id

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

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
340: and paa.person_id = ppei.person_id -- and paa.assignment_id = paei.assignment_id /* Bug 2691877 */

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

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
340: and paa.person_id = ppei.person_id -- and paa.assignment_id = paei.assignment_id /* Bug 2691877 */
341: and ac3.context = ppei.person_extra_info_id -- and ac3.context = paei.assignment_extra_info_id

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

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
384: and paa.person_id = ppei.person_id -- and paa.assignment_id = paei.assignment_id /* Bug 2691877 */

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

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
384: and paa.person_id = ppei.person_id -- and paa.assignment_id = paei.assignment_id /* Bug 2691877 */
385: and ac3.context = ppei.person_extra_info_id -- and ac3.context = paei.assignment_extra_info_id

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

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
424: and paa.person_id = ppei.person_id -- and paa.assignment_id = paei.assignment_id /* Bug 2691877*/

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

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
424: and paa.person_id = ppei.person_id -- and paa.assignment_id = paei.assignment_id /* Bug 2691877*/
425: and ac3.context = ppei.person_extra_info_id -- and ac3.context = paei.assignment_extra_info_id