VIEW: APPS.CE_CP_DISC_PAY_V

Source

View Text - Preformatted

SELECT WSL.worksheet_header_id, PAY.bank_account_id, WSL.worksheet_line_id, WSL.description, to_char(PAY.reference_id), -decode(PAY.currency_code, XBA.currency_code, PAY.amount, PAY.base_amount), PAY.reference_id FROM CE_PAY_FC_PAYROLL_V PAY, CE_CP_WORKSHEET_LINES WSL, CE_CP_XTR_BANK_ACCOUNTS_V XBA WHERE PAY.trx_date = to_date(sysdate,'YYYY/MM/DD') AND WSL.source_type = 'PAY' AND WSL.include_flag = 'Y' AND (WSL.payroll_id is null OR PAY.payroll_id = WSL.payroll_id) AND (WSL.receipt_method_id is null OR PAY.org_payment_method_id = WSL.receipt_method_id) AND PAY.bank_account_id = XBA.bank_account_id

View Text - HTML Formatted

SELECT WSL.WORKSHEET_HEADER_ID
, PAY.BANK_ACCOUNT_ID
, WSL.WORKSHEET_LINE_ID
, WSL.DESCRIPTION
, TO_CHAR(PAY.REFERENCE_ID)
, -DECODE(PAY.CURRENCY_CODE
, XBA.CURRENCY_CODE
, PAY.AMOUNT
, PAY.BASE_AMOUNT)
, PAY.REFERENCE_ID
FROM CE_PAY_FC_PAYROLL_V PAY
, CE_CP_WORKSHEET_LINES WSL
, CE_CP_XTR_BANK_ACCOUNTS_V XBA
WHERE PAY.TRX_DATE = TO_DATE(SYSDATE
, 'YYYY/MM/DD')
AND WSL.SOURCE_TYPE = 'PAY'
AND WSL.INCLUDE_FLAG = 'Y'
AND (WSL.PAYROLL_ID IS NULL OR PAY.PAYROLL_ID = WSL.PAYROLL_ID)
AND (WSL.RECEIPT_METHOD_ID IS NULL OR PAY.ORG_PAYMENT_METHOD_ID = WSL.RECEIPT_METHOD_ID)
AND PAY.BANK_ACCOUNT_ID = XBA.BANK_ACCOUNT_ID