eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PAY_LIST_ELEMENT_ENTRIES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_LIST_ELEMENT_ENTRIES_V

View Text

SELECT EE.ELEMENT_ENTRY_ID
, EE.EFFECTIVE_START_DATE
, EE.EFFECTIVE_END_DATE
, EE.COST_ALLOCATION_KEYFLEX_ID
, EE.ASSIGNMENT_ID
, P.FULL_NAME
, A.ASSIGNMENT_NUMBER
, EE.UPDATING_ACTION_ID
, EE.ELEMENT_LINK_ID
, EE.ORIGINAL_ENTRY_ID
, EE.CREATOR_TYPE
, EE.ENTRY_TYPE
, EE.COMMENT_ID
, EE.CREATOR_ID
, EE.REASON
, EE.TARGET_ENTRY_ID
FROM PAY_ELEMENT_ENTRIES_F EE
, PER_ASSIGNMENTS_F A
, PER_PEOPLE_F P
WHERE EE.ASSIGNMENT_ID = A.ASSIGNMENT_ID
AND EE.EFFECTIVE_START_DATE BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND A.PERSON_ID = P.PERSON_ID
AND EE.EFFECTIVE_START_DATE BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE

Columns

Name
ELEMENT_ENTRY_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
COST_ALLOCATION_KEYFLEX_ID
ASSIGNMENT_ID
FULL_NAME
ASSIGNMENT_NUMBER
UPDATING_ACTION_ID
ELEMENT_LINK_ID
ORIGINAL_ENTRY_ID
CREATOR_TYPE
ENTRY_TYPE
COMMENT_ID
CREATOR_ID
REASON
TARGET_ENTRY_ID