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

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

41: 'TEST_FLAG=P',
42: 'Y'
43: from pay_assignment_actions ppac,
44: pay_payroll_actions ppa
45: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
46: and ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters)
47: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
48: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
49: and ppac.action_status = 'C'

Line 73: and mpac.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

69: and mpac.assignment_Action_id = mpai.locking_action_id
70: and ppa.payroll_action_id = ppac.payroll_Action_id
71: and apac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
72: and ppac.assignment_action_id = mpai.locked_action_id
73: and mpac.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
74: and apac.action_status = 'C'
75: and ppac.action_status = 'C' /* Bug No : 3288757 */
76: /*Bug 3400521 - Added the following joins to improve the performance*/
77: and ppa.action_status = 'C'

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

99: pay_assignment_actions ppac,
100: pay_payroll_actions ppa,
101: ff_archive_items ff,
102: ff_user_entities fue
103: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
104: and ppac.action_status='C'
105: and ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters)
106: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
107: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */

Line 139: where mpac.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

135: pay_assignment_actions apac, --archive
136: pay_payroll_actions ppa, --self printed
137: ff_archive_items ff,
138: ff_user_entities fue
139: where mpac.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
140: and mpac.action_status ='C'
141: and ppac.action_status='C'
142: and mpai.locking_action_id = mpac.assignment_Action_id -- magtapes locking action id
143: and ppac.assignment_action_id = mpai.locked_action_id --self printed locked by maghtape

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

163: ppac.assignment_action_id ps_report_id
164: from pay_assignment_actions ppac,
165: pay_payroll_actions mpa,
166: pay_assignment_actions mpac
167: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
168: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
169: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */
170: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)
171: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'

Line 208: and mpac.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

204: and apac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
205: and ppai.locking_Action_id = ppac.assignment_action_id /* 5471093 */
206: and ppac.assignment_action_id = mpai.locked_action_id
207: and mpac.assignment_Action_id = mpai.locking_action_id
208: and mpac.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
209: and apac.action_status = 'C'
210: and ppac.action_status = 'C' /* Bug No : 3288757 */
211: /*Bug 3400521 - Added the following joins to improve the performance*/
212: and mpac.action_status = 'C'

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

246: ppac.assignment_action_id ps_report_id
247: from pay_assignment_actions ppac,
248: pay_payroll_actions mpa,
249: pay_assignment_actions mpac
250: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
251: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
252: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */
253: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)
254: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'

Line 286: where mpac.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

282: pay_assignment_actions ppac, --Self Printed
283: pay_action_interlocks ppai,
284: pay_assignment_actions apac, --Archive
285: pay_payroll_actions ppa --Self Printed
286: where mpac.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
287: and mpac.action_status = 'C'
288: and ppac.action_status = 'C'
289: and mpac.assignment_Action_id = mpai.locking_action_id
290: and ppac.assignment_action_id = mpai.locked_action_id