VIEW: APPS.PAY_LIST_ELEMENT_ENTRIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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