[Home] [Help]
View: CE_FC_PAY_DISC_V
View Text
SELECT TO_CHAR(SRC.REFERENCE_ID)
, PAY.PAYROLL_NAME
, -SRC.AMOUNT
, -NVL(SRC.BASE_AMOUNT
, SRC.AMOUNT)
, SRC.PAYMENT_METHOD
, HR.NAME FROM CE_PAY_FC_PAYROLL_V SRC
, PAY_ALL_PAYROLLS_F PAY
, HR_ALL_ORGANIZATION_UNITS HR
WHERE PAY.PAYROLL_ID(+) = SRC.PAYROLL_ID
AND HR.ORGANIZATION_ID(+) = SRC.ORG_ID
AND EXISTS (SELECT NULL
FROM CE_SECURITY_PROFILES_V SEC
WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID
AND SEC.ORGANIZATION_TYPE = 'BUSINESS_GROUP')
Columns
Name |
REFERENCE_ID |
PAYROLL_NAME |
TRX_AMOUNT |
BANK_ACCOUNT_AMOUNT |
PAYMENT_METHOD |
ORGANIZATION |