View: PAY_PAYMENT_COSTS_V

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

View Text

SELECT OPM.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD_NAME
, PCOS.ACCOUNTING_DATE ACCOUNTING_DATE
, HR_GENERAL.DECODE_LOOKUP('PAY_COST_ACCOUNT_TYPE'
, PCOS.ACCOUNT_TYPE) COST_TYPE
, HR_GENERAL.DECODE_LOOKUP('DEBIT_CREDIT'
, PCOS.DEBIT_OR_CREDIT ) DEBIT_OR_CREDIT
, HR_CHKFMT.CHANGEFORMAT(PCOS.VALUE
, 'M'
, PCOS.CURRENCY_CODE) COSTED_VALUE
, PCOS.SOURCE_TYPE SOURCE_TYPE
, PCOS.SOURCE_ACTION_ID SOURCE_ACTION_ID
, PCOS.ACCOUNT_ID GL_ACCOUNT_CCID
, GCC.CHART_OF_ACCOUNTS_ID FLEX_NUM
FROM PAY_PAYMENT_COSTS PCOS
, PAY_PRE_PAYMENTS PPP
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PAC
, GL_CODE_COMBINATIONS GCC
WHERE PCOS.PRE_PAYMENT_ID = PPP.PRE_PAYMENT_ID
AND PPP.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND PAA.ASSIGNMENT_ACTION_ID = PCOS.ASSIGNMENT_ACTION_ID
AND PAA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PAC.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE
AND GCC.CODE_COMBINATION_ID = PCOS.ACCOUNT_ID

Columns