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_ORG_PAYMENT_METHODS

Line 159: pay_org_payment_methods popm

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
163: AND ppp.org_payment_method_id = popm.org_payment_method_id

Line 248: pay_org_payment_methods popm,

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,
252: pay_input_values piv

Line 293: pay_org_payment_methods popm,

289: popm.ORG_PAYMENT_METHOD_NAME
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')

Line 419: PAY_ORG_PAYMENT_METHODS org,

415: org.pmeth_information3,
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 =

Line 446: pay_org_payment_methods org,

442: org.currency_code,
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 =

Line 471: pay_org_payment_methods org

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 =
475: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 522: PAY_ORG_PAYMENT_METHODS org,

518: org.pmeth_information3,
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 =

Line 549: pay_org_payment_methods org,

545: org.currency_code,
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 =

Line 586: pay_org_payment_methods org,

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,
590: pay_input_values piv

Line 633: pay_org_payment_methods org,

629: 'ORG_PAY_METHOD_NAME=P', org.org_payment_method_name
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')