FND Design Data [Home] [Help]

View: PSP_PAYROLL_BATCH_NAMES_V

Product: PSP - Labor Distribution
Description: Based on the PSP_PAYROLL_INTERFACE table
Implementation/DBA Data: ViewAPPS.PSP_PAYROLL_BATCH_NAMES_V
View Text

SELECT DISTINCT BATCH_NAME
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
, NVL(CURRENCY_CODE
, PSP_GENERAL.GET_CURRENCY_CODE(BUSINESS_GROUP_ID)) CURRENCY_CODE
, GL_POSTING_OVERRIDE_DATE
FROM PSP_PAYROLL_INTERFACE
WHERE STATUS_CODE != 'T'

Columns

Name
BATCH_NAME
BUSINESS_GROUP_ID
SET_OF_BOOKS_ID
CURRENCY_CODE
GL_POSTING_OVERRIDE_DATE