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_ELEMENT_TYPES

Line 252: pay_element_types pet,

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
255: where paa.payroll_action_id =
256: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 307: from pay_element_types pet,

303: from pay_action_interlocks pai
304: where ppp.assignment_action_id=pai.locking_action_id
305: )
306: and not exists (select 1
307: from pay_element_types pet,
308: pay_run_results prr
309: where prr.assignment_action_id = paa2.assignment_action_id
310: and pet.element_type_id = prr.element_type_id
311: and pet.element_name = 'BACS Process Date')

Line 344: pay_element_types pet,

340: and exists (
341: select 1
342: from pay_input_values piv,
343: pay_run_result_values prrv,
344: pay_element_types pet,
345: pay_run_results prr
346: where prr.assignment_action_id =
347: (select max(pai.locked_action_id)
348: from pay_action_interlocks pai

Line 395: from pay_element_types pet,

391: and to_date(pay_magtape_generic.get_parameter_value(
392: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
393: > ptp.default_dd_date))
394: and not exists (select 1
395: from pay_element_types pet,
396: pay_run_results prr
397: where prr.assignment_action_id = paa.assignment_action_id
398: and pet.element_type_id = prr.element_type_id
399: and pet.element_name = 'BACS Process Date')

Line 590: pay_element_types pet,

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
593: where org.currency_code =
594: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')

Line 653: from pay_element_types pet,

649: from pay_action_interlocks pai
650: where ppp.assignment_action_id=pai.locking_action_id
651: )
652: and not exists (select 1
653: from pay_element_types pet,
654: pay_run_results prr
655: where prr.assignment_action_id = paa2.assignment_action_id
656: and pet.element_type_id = prr.element_type_id
657: and pet.element_name = 'BACS Process Date')

Line 690: pay_element_types pet,

686: and exists (
687: select 1
688: from pay_input_values piv,
689: pay_run_result_values prrv,
690: pay_element_types pet,
691: pay_run_results prr
692: where prr.assignment_action_id =
693: (select max(pai.locked_action_id)
694: from pay_action_interlocks pai

Line 741: from pay_element_types pet,

737: and to_date(pay_magtape_generic.get_parameter_value(
738: 'TRANSFER_PER_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')
739: > ptp.default_dd_date))
740: and not exists (select 1
741: from pay_element_types pet,
742: pay_run_results prr
743: where prr.assignment_action_id = paa.assignment_action_id
744: and pet.element_type_id = prr.element_type_id
745: and pet.element_name = 'BACS Process Date')