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_BACS_TAPE dependencies on PAY_PRE_PAYMENTS

Line 136: pay_pre_payments ppp,

132: to_char(ppa.overriding_dd_date, 'YYYY/MM/DD HH24:MI:SS'),
133: 'TRANSFER_FORMAT_TYPE=P',
134: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
135: from fnd_sessions fnd,
136: pay_pre_payments ppp,
137: pay_assignment_actions paa,
138: pay_payroll_actions ppa
139: where paa.payroll_action_id =
140: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 158: pay_pre_payments ppp,

154: popm.currency_code,
155: 'ORG_PAY_METHOD_NAME=P',
156: popm.ORG_PAYMENT_METHOD_NAME
157: from pay_assignment_actions paa,
158: pay_pre_payments ppp,
159: pay_org_payment_methods popm
160: WHERE paa.payroll_action_id =
161: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
162: AND ppp.pre_payment_id = paa.pre_payment_id

Line 178: pay_pre_payments ppp,

174: paa.assignment_action_id
175: from pay_external_accounts pea,
176: pay_personal_payment_methods ppm,
177: per_assignments pa,
178: pay_pre_payments ppp,
179: pay_assignment_actions paa
180: where paa.payroll_action_id =
181: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
182: and paa.pre_payment_id = ppp.pre_payment_id

Line 214: pay_pre_payments ppp,

210: to_char(ppa.overriding_dd_date, 'YYDDD'),
211: 'TRANSFER_FORMAT_TYPE=P',
212: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
213: from fnd_sessions fnd,
214: pay_pre_payments ppp,
215: pay_assignment_actions paa,
216: pay_payroll_actions ppa
217: where paa.payroll_action_id =
218: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 247: pay_pre_payments ppp,

243: popm.currency_code,
244: 'ORG_PAY_METHOD_NAME=P',
245: popm.ORG_PAYMENT_METHOD_NAME
246: from pay_assignment_actions paa,
247: pay_pre_payments ppp,
248: pay_org_payment_methods popm,
249: pay_run_results prr,
250: pay_element_types pet,
251: pay_run_result_values prrv,

Line 294: pay_pre_payments ppp,

290: from per_time_periods ptp,
291: pay_payroll_actions ppa,
292: pay_assignment_actions paa2,
293: pay_org_payment_methods popm,
294: pay_pre_payments ppp,
295: pay_assignment_actions paa
296: where paa.payroll_action_id =
297: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
298: and ppp.pre_payment_id = paa.pre_payment_id

Line 328: pay_pre_payments oppp,

324: opaa.assignment_action_id
325: from pay_external_accounts opea,
326: pay_personal_payment_methods oppm,
327: per_assignments opa,
328: pay_pre_payments oppp,
329: pay_assignment_actions opaa
330: where opaa.payroll_action_id =
331: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
332: and opa.assignment_id = opaa.assignment_id

Line 420: pay_pre_payments ppp,

416: 'TRANSFER_FORMAT_TYPE=P',
417: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
418: from fnd_sessions fnd,
419: PAY_ORG_PAYMENT_METHODS org,
420: pay_pre_payments ppp,
421: pay_assignment_actions paa,
422: pay_payroll_actions ppa
423: where paa.payroll_action_id =
424: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 447: pay_pre_payments ppp,

443: 'ORG_PAY_METHOD_NAME=P',
444: min(org.org_payment_method_name)
445: from fnd_sessions fnd,
446: pay_org_payment_methods org,
447: pay_pre_payments ppp,
448: pay_assignment_actions paa,
449: pay_payroll_actions ppa
450: where paa.payroll_action_id =
451: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 470: pay_pre_payments ppp,

466: org.pmeth_information3,
467: 'ORG_PAY_METHOD_NAME=P',
468: org.org_payment_method_name
469: FROM pay_assignment_actions paa,
470: pay_pre_payments ppp,
471: pay_org_payment_methods org
472: WHERE org.currency_code =
473: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')
474: and paa.payroll_action_id =

Line 492: pay_pre_payments ppp,

488: ppp.personal_payment_method_id,
489: 'TRANSFER_ASG_ACTION_ID=P',
490: paa.assignment_action_id
491: from pay_assignment_actions paa,
492: pay_pre_payments ppp,
493: per_assignments pa,
494: pay_personal_payment_methods ppm,
495: pay_external_accounts pea
496: where paa.payroll_action_id =

Line 523: pay_pre_payments ppp,

519: 'TRANSFER_FORMAT_TYPE=P',
520: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
521: from fnd_sessions fnd,
522: PAY_ORG_PAYMENT_METHODS org,
523: pay_pre_payments ppp,
524: pay_payroll_actions ppa,
525: pay_assignment_actions paa
526: where paa.payroll_action_id =
527: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 550: pay_pre_payments ppp,

546: 'ORG_PAY_METHOD_NAME=P',
547: min(org.org_payment_method_name)
548: from fnd_sessions fnd,
549: pay_org_payment_methods org,
550: pay_pre_payments ppp,
551: pay_payroll_actions ppa,
552: pay_assignment_actions paa
553: where paa.payroll_action_id =
554: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 585: pay_pre_payments ppp,

581: org.pmeth_information3,
582: 'ORG_PAY_METHOD_NAME=P',
583: org.org_payment_method_name
584: from pay_assignment_actions paa,
585: pay_pre_payments ppp,
586: pay_org_payment_methods org,
587: pay_run_results prr,
588: pay_element_types pet,
589: pay_run_result_values prrv,

Line 634: pay_pre_payments ppp,

630: from per_time_periods ptp,
631: pay_payroll_actions ppa,
632: pay_assignment_actions paa2,
633: pay_org_payment_methods org,
634: pay_pre_payments ppp,
635: pay_assignment_actions paa
636: where org.currency_code =
637: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')
638: and paa.payroll_action_id =

Line 674: pay_pre_payments oppp,

670: from
671: pay_external_accounts opea,
672: pay_personal_payment_methods oppm,
673: per_assignments opa,
674: pay_pre_payments oppp,
675: pay_assignment_actions opaa
676: where opaa.payroll_action_id =
677: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
678: and opa.assignment_id = opaa.assignment_id