View: PAY_BALANCE_ADJUSTMENTS_V

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

View Text

SELECT PETTL.ELEMENT_NAME
, PEE.CREATOR_ID ASSIGNMENT_ACTION_ID
, PEE.ASSIGNMENT_ID
, PEE.ELEMENT_ENTRY_ID
FROM PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_TYPES_F_TL PETTL
WHERE PEE.ENTRY_TYPE = 'B'
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PEE.EFFECTIVE_START_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND PETTL.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')

Columns