DBA Data[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on PAY_RUN_RESULT_VALUES

Line 253: pay_run_result_values prrv,

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')
257: and prr.assignment_action_id =

Line 343: pay_run_result_values prrv,

339: and opea.external_account_id = oppm.external_account_id
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)

Line 591: pay_run_result_values prrv,

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')
595: and paa.payroll_action_id =

Line 689: pay_run_result_values prrv,

685: and opea.external_account_id = oppm.external_account_id
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)