APPS.PAY_GB_BACS_TAPE dependencies on PAY_RUN_RESULTS

Line 251: pay_run_results prr,

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

Line 308: pay_run_results prr

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')
312: and paa2.payroll_action_id = ppa.payroll_action_id

Line 345: pay_run_results prr

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
349: where oppp.assignment_action_id=pai.locking_action_id

Line 396: pay_run_results prr

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')
400: )

Line 589: pay_run_results prr,

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

Line 654: pay_run_results prr

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')
658: and paa2.payroll_action_id = ppa.payroll_action_id

Line 691: pay_run_results prr

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
695: where oppp.assignment_action_id=pai.locking_action_id

Line 742: pay_run_results prr

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')
746: )