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.

[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on PAY_PRE_PAYMENTS

Line 138: pay_pre_payments ppp,

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

Line 160: pay_pre_payments ppp,

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

Line 180: pay_pre_payments ppp,

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

Line 216: pay_pre_payments ppp,

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

Line 249: pay_pre_payments ppp,

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

Line 296: pay_pre_payments ppp,

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

Line 330: pay_pre_payments oppp,

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

Line 422: pay_pre_payments ppp,

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

Line 449: pay_pre_payments ppp,

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

Line 472: pay_pre_payments ppp,

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

Line 494: pay_pre_payments ppp,

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

Line 525: pay_pre_payments ppp,

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

Line 552: pay_pre_payments ppp,

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

Line 587: pay_pre_payments ppp,

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

Line 636: pay_pre_payments ppp,

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

Line 676: pay_pre_payments oppp,

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