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_RUN_RESULTS

Line 249: pay_run_results prr,

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
253: where paa.payroll_action_id =

Line 306: pay_run_results prr

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

Line 343: pay_run_results prr

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

Line 394: pay_run_results prr

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

Line 587: pay_run_results prr,

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
591: where org.currency_code =

Line 652: pay_run_results prr

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

Line 689: pay_run_results prr

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

Line 740: pay_run_results prr

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