VIEW: APPS.PSP_PAYROLL_BATCH_NAMES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'