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 351: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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

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

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

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

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

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

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

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

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