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_ARCHIVE dependencies on PAY_MAGTAPE_GENERIC

Line 349: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

345: from pay_payroll_actions ppa,
346: pay_assignment_actions pac,
347: ff_archive_items ffi,
348: ff_database_items fdi
349: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
350: and ppa.payroll_action_id = pac.payroll_action_id
351: and pac.action_status = 'C'
352: and ffi.context1 = pac.assignment_action_id /* Added joins for bug:3232300 */
353: and fdi.user_name = 'X_SG_LEGAL_ENTITY_SG_LEGAL_ENTITY_NAME'

Line 378: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

374: pay_payroll_actions ppa,
375: pay_assignment_actions pac,
376: ff_archive_items fai,
377: ff_archive_item_contexts ac2
378: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
379: and pac.action_status = 'C'
380: and ppa.payroll_action_id = pac.payroll_action_id
381: and paa.assignment_id = pac.assignment_id
382: and ppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

Line 382: and ppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

378: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
379: and pac.action_status = 'C'
380: and ppa.payroll_action_id = pac.payroll_action_id
381: and paa.assignment_id = pac.assignment_id
382: and ppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
383: and paa.business_group_id = ppa.business_group_id
384: and fai.context1 = pac.assignment_action_id
385: and fai.archive_item_id = ac2.archive_item_id and ac2.sequence_no = 2
386: order by paa.person_id;

Line 401: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

397: pay_payroll_actions ppa,
398: pay_assignment_actions pac,
399: ff_archive_items fai,
400: ff_archive_item_contexts ac2
401: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
402: and pac.action_status = 'C'
403: and ppa.payroll_action_id = pac.payroll_action_id
404: and paa.assignment_id = pac.assignment_id
405: and ppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

Line 405: and ppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

401: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
402: and pac.action_status = 'C'
403: and ppa.payroll_action_id = pac.payroll_action_id
404: and paa.assignment_id = pac.assignment_id
405: and ppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
406: AND paa.business_group_id = ppa.business_group_id
407: and fai.context1 = pac.assignment_action_id
408: and fai.archive_item_id = ac2.archive_item_id and ac2.sequence_no = 2
409: order by paa.person_id;