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 140: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

136: ----------------------------------------------------------
137: -- Bug 4059844 - SQL Repository Perf
138: -- pay_payroll_actions pact,
139: pay_action_information pai
140: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
141: ('TRANSFER_PAYROLL_ACTION_ID')
142: AND act_edi.assignment_action_id = pai.action_context_id
143: AND pai.action_context_type = 'AAP'
144: AND pai.action_information_category = 'GB P46 CAR EDI EMPLOYEE DETAIL'

Line 178: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value

174: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
175: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
176: FROM pay_payroll_actions pact,
177: hr_organization_information hoi
178: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
179: ('TRANSFER_PAYROLL_ACTION_ID')
180: AND hoi.org_information_context = 'Tax Details References'
181: AND substr(pact.legislative_parameters,
182: instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 219: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

215: 'INTERVAL_OF_PAYMENT=P', nvl(action_information22, 'Y') -- Added for the bug 9354919
216: FROM pay_assignment_actions act_edi,
217: per_all_assignments_f asg,
218: pay_action_information pai
219: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
220: ('TRANSFER_PAYROLL_ACTION_ID')
221: AND asg.person_id = pay_magtape_generic.get_parameter_value(
222: 'PERSON_ID')
223: AND act_edi.assignment_id = asg.assignment_id

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

217: per_all_assignments_f asg,
218: pay_action_information pai
219: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
220: ('TRANSFER_PAYROLL_ACTION_ID')
221: AND asg.person_id = pay_magtape_generic.get_parameter_value(
222: 'PERSON_ID')
223: AND act_edi.assignment_id = asg.assignment_id
224: AND act_edi.assignment_action_id = pai.action_context_id
225: AND pai.action_context_type = 'AAP'

Line 258: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

254: ----------------------------------------------------------
255: -- Bug 4059844 - SQL Repository Perf
256: -- pay_payroll_actions pact,
257: pay_action_information pai
258: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
259: ('TRANSFER_PAYROLL_ACTION_ID')
260: AND act_edi.assignment_action_id = pai.action_context_id
261: AND pai.action_context_type = 'AAP'
262: AND pai.action_information_category = 'GB P46 CAR EDI EMPLOYEE DETAIL'

Line 297: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value

293: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
294: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
295: FROM pay_payroll_actions pact,
296: hr_organization_information hoi
297: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
298: ('TRANSFER_PAYROLL_ACTION_ID')
299: AND hoi.org_information_context = 'Tax Details References'
300: AND substr(pact.legislative_parameters,
301: instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 337: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value

333: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
334: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
335: FROM pay_payroll_actions pact,
336: hr_organization_information hoi
337: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
338: ('TRANSFER_PAYROLL_ACTION_ID')
339: AND hoi.org_information_context = 'Tax Details References'
340: AND substr(pact.legislative_parameters,
341: instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 378: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

374: 'INTERVAL_OF_PAYMENT=P', nvl(action_information22, 'Y') -- Added for the bug 9354919
375: FROM pay_assignment_actions act_edi,
376: per_all_assignments_f asg,
377: pay_action_information pai
378: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
379: ('TRANSFER_PAYROLL_ACTION_ID')
380: AND asg.person_id = pay_magtape_generic.get_parameter_value(
381: 'PERSON_ID')
382: AND act_edi.assignment_id = asg.assignment_id

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

376: per_all_assignments_f asg,
377: pay_action_information pai
378: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
379: ('TRANSFER_PAYROLL_ACTION_ID')
380: AND asg.person_id = pay_magtape_generic.get_parameter_value(
381: 'PERSON_ID')
382: AND act_edi.assignment_id = asg.assignment_id
383: AND act_edi.assignment_action_id = pai.action_context_id
384: AND pai.action_context_type = 'AAP'

Line 417: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

413: ----------------------------------------------------------
414: -- Bug 4059844 - SQL Repository Perf
415: -- pay_payroll_actions pact,
416: pay_action_information pai
417: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
418: ('TRANSFER_PAYROLL_ACTION_ID')
419: AND act_edi.assignment_action_id = pai.action_context_id
420: AND pai.action_context_type = 'AAP'
421: AND pai.action_information_category = 'GB P46 CAR EDI EMPLOYEE DETAIL'

Line 451: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

447: 'INTERVAL_OF_PAYMENT=P', nvl(action_information22, 'Y') -- Added for the bug 9354919
448: FROM pay_assignment_actions act_edi,
449: per_all_assignments_f asg,
450: pay_action_information pai
451: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
452: ('TRANSFER_PAYROLL_ACTION_ID')
453: AND asg.person_id = pay_magtape_generic.get_parameter_value(
454: 'PERSON_ID')
455: AND act_edi.assignment_id = asg.assignment_id

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

449: per_all_assignments_f asg,
450: pay_action_information pai
451: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
452: ('TRANSFER_PAYROLL_ACTION_ID')
453: AND asg.person_id = pay_magtape_generic.get_parameter_value(
454: 'PERSON_ID')
455: AND act_edi.assignment_id = asg.assignment_id
456: AND act_edi.assignment_action_id = pai.action_context_id
457: AND pai.action_context_type = 'AAP'