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

Line 86: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value

82: upper(nvl(substr(hoi.org_information4,1,60),' ')),
83: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' '))
84: FROM pay_payroll_actions pact,
85: hr_organization_information hoi
86: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
87: ('TRANSFER_PAYROLL_ACTION_ID')
88: AND hoi.org_information_context = 'Tax Details References'
89: AND substr(pact.legislative_parameters,
90: instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 144: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

140: pay_assignment_actions act,
141: pay_payroll_actions pact,
142: ff_archive_items fai,
143: ff_user_entities fue
144: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
145: ('TRANSFER_PAYROLL_ACTION_ID')
146: AND act_edi.assignment_action_id = pai.locking_action_id
147: AND act.assignment_action_id = pai.locked_action_id
148: AND pact.payroll_action_id = act.payroll_action_id

Line 179: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value

175: (legislative_parameters,
176: 'TEST_ID'),' ') /*added for P45PT1*/
177: FROM pay_payroll_actions pact,
178: hr_organization_information hoi
179: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
180: ('TRANSFER_PAYROLL_ACTION_ID')
181: AND hoi.org_information_context = 'Tax Details References'
182: AND substr(pact.legislative_parameters,
183: instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 241: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

237: pay_assignment_actions act,
238: pay_payroll_actions pact,
239: ff_archive_items fai,
240: ff_user_entities fue
241: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
242: ('TRANSFER_PAYROLL_ACTION_ID')
243: AND act_edi.assignment_action_id = pai.locking_action_id
244: AND act.assignment_action_id = pai.locked_action_id
245: AND pact.payroll_action_id = act.payroll_action_id

Line 276: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value

272: (legislative_parameters,
273: 'TEST_ID'),' ') /*added for P45PT1*/
274: FROM pay_payroll_actions pact,
275: hr_organization_information hoi
276: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
277: ('TRANSFER_PAYROLL_ACTION_ID')
278: AND hoi.org_information_context = 'Tax Details References'
279: AND substr(pact.legislative_parameters,
280: instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 338: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

334: pay_assignment_actions act,
335: pay_payroll_actions pact,
336: ff_archive_items fai,
337: ff_user_entities fue
338: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
339: ('TRANSFER_PAYROLL_ACTION_ID')
340: AND act_edi.assignment_action_id = pai.locking_action_id
341: AND act.assignment_action_id = pai.locked_action_id
342: AND pact.payroll_action_id = act.payroll_action_id