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 161: pay_org_payment_methods popm

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

Line 250: pay_org_payment_methods popm,

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

Line 295: pay_org_payment_methods popm,

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

Line 421: PAY_ORG_PAYMENT_METHODS org,

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

Line 448: pay_org_payment_methods org,

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

Line 473: pay_org_payment_methods org

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

Line 524: PAY_ORG_PAYMENT_METHODS org,

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

Line 551: pay_org_payment_methods org,

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

Line 588: pay_org_payment_methods org,

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

Line 635: pay_org_payment_methods org,

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