View: PAY_XLA_PAYMENT_COSTS_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_XLA_PAYMENT_COSTS_V

View Text

SELECT PXE.EVENT_ID
, PPC.PAYMENT_COST_ID
, TGL_AA.ASSIGNMENT_ACTION_ID
, PPC.ASSIGNMENT_ACTION_ID
, PPC.VALUE
, PPC.DEBIT_OR_CREDIT
, PPC.CURRENCY_CODE
, PPC.ACCOUNT_ID
, PPC.ACCOUNT_TYPE
, PPC.ACCOUNTING_DATE
FROM PAY_XLA_EVENTS PXE
, PAY_ASSIGNMENT_ACTIONS TGL_AA
, PAY_ACTION_INTERLOCKS COST_LOCK
, PAY_ASSIGNMENT_ACTIONS COST_AA
, PAY_PAYROLL_ACTIONS COST_PA
, PAY_PAYMENT_COSTS PPC
WHERE TGL_AA.ASSIGNMENT_ACTION_ID = PXE.ASSIGNMENT_ACTION_ID
AND COST_LOCK.LOCKING_ACTION_ID = TGL_AA.ASSIGNMENT_ACTION_ID
AND COST_AA.ASSIGNMENT_ACTION_ID = COST_LOCK.LOCKED_ACTION_ID
AND COST_PA.PAYROLL_ACTION_ID = COST_AA.PAYROLL_ACTION_ID
AND COST_PA.ACTION_TYPE = 'CP'
AND PPC.ASSIGNMENT_ACTION_ID = COST_AA.ASSIGNMENT_ACTION_ID
AND PPC.TRANSFER_TO_GL_FLAG = 'Y'
AND PPC.ACCOUNTING_DATE = PXE.ACCOUNTING_DATE

Columns