DBA Data[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on PAY_RUN_RESULT_VALUES

Line 251: pay_run_result_values prrv,

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 =
254: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
255: and prr.assignment_action_id =

Line 341: pay_run_result_values prrv,

337: and opea.external_account_id = oppm.external_account_id
338: and exists (
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)

Line 589: pay_run_result_values prrv,

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 =
592: pay_magtape_generic.get_parameter_value('TRANSFER_CURRENCY_CODE')
593: and paa.payroll_action_id =

Line 687: pay_run_result_values prrv,

683: and opea.external_account_id = oppm.external_account_id
684: and exists (
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)