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

Line 78: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value

74: upper(nvl(substr(hoi.org_information4,1,60),' ')),
75: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' '))
76: FROM pay_payroll_actions pact,
77: hr_organization_information hoi
78: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
79: ('TRANSFER_PAYROLL_ACTION_ID')
80: AND hoi.org_information_context = 'Tax Details References'
81: AND substr(pact.legislative_parameters,
82: instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 116: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

112: ----------------------------------------------------------
113: -- Bug 4059844 - SQL Repository Perf
114: -- pay_payroll_actions pact,
115: pay_action_information pai
116: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
117: ('TRANSFER_PAYROLL_ACTION_ID')
118: AND act_edi.assignment_action_id = pai.action_context_id
119: AND pai.action_context_type = 'AAP'
120: AND pai.action_information_category = 'GB P46 CAR EDI EMPLOYEE DETAIL'

Line 153: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

149: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' ')
150: FROM pay_assignment_actions act_edi,
151: per_all_assignments_f asg,
152: pay_action_information pai
153: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
154: ('TRANSFER_PAYROLL_ACTION_ID')
155: AND asg.person_id = pay_magtape_generic.get_parameter_value(
156: 'PERSON_ID')
157: AND act_edi.assignment_id = asg.assignment_id

Line 155: AND asg.person_id = pay_magtape_generic.get_parameter_value(

151: per_all_assignments_f asg,
152: pay_action_information pai
153: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
154: ('TRANSFER_PAYROLL_ACTION_ID')
155: AND asg.person_id = pay_magtape_generic.get_parameter_value(
156: 'PERSON_ID')
157: AND act_edi.assignment_id = asg.assignment_id
158: AND act_edi.assignment_action_id = pai.action_context_id
159: AND pai.action_context_type = 'AAP'

Line 194: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value

190: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
191: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
192: FROM pay_payroll_actions pact,
193: hr_organization_information hoi
194: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
195: ('TRANSFER_PAYROLL_ACTION_ID')
196: AND hoi.org_information_context = 'Tax Details References'
197: AND substr(pact.legislative_parameters,
198: instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 235: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

231: ----------------------------------------------------------
232: -- Bug 4059844 - SQL Repository Perf
233: -- pay_payroll_actions pact,
234: pay_action_information pai
235: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
236: ('TRANSFER_PAYROLL_ACTION_ID')
237: AND act_edi.assignment_action_id = pai.action_context_id
238: AND pai.action_context_type = 'AAP'
239: AND pai.action_information_category = 'GB P46 CAR EDI EMPLOYEE DETAIL'

Line 272: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

268: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' ')
269: FROM pay_assignment_actions act_edi,
270: per_all_assignments_f asg,
271: pay_action_information pai
272: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
273: ('TRANSFER_PAYROLL_ACTION_ID')
274: AND asg.person_id = pay_magtape_generic.get_parameter_value(
275: 'PERSON_ID')
276: AND act_edi.assignment_id = asg.assignment_id

Line 274: AND asg.person_id = pay_magtape_generic.get_parameter_value(

270: per_all_assignments_f asg,
271: pay_action_information pai
272: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
273: ('TRANSFER_PAYROLL_ACTION_ID')
274: AND asg.person_id = pay_magtape_generic.get_parameter_value(
275: 'PERSON_ID')
276: AND act_edi.assignment_id = asg.assignment_id
277: AND act_edi.assignment_action_id = pai.action_context_id
278: AND pai.action_context_type = 'AAP'