View: BEN_BENEFICIARIES_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.BEN_BENEFICIARIES_V

View Text

SELECT B.ROWID ROW_ID
, B.BENEFICIARY_ID
, C.FULL_NAME BENEFICIARY
, B.SOURCE_ID
, B.SOURCE_TYPE
, S.MEANING SOURCE_DESCRIPTION
, B.ELEMENT_ENTRY_ID
, B.BENEFIT_LEVEL
, L.MEANING LEVEL_DESCRIPTION
, B.PROPORTION
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
FROM HR_LOOKUPS L
, HR_LOOKUPS S
, FND_SESSIONS FND
, PER_PEOPLE_F C
, BEN_BENEFICIARIES_F B
WHERE B.SOURCE_ID = C.PERSON_ID
AND B.SOURCE_TYPE = 'P'
AND B.SOURCE_TYPE = S.LOOKUP_CODE
AND S.LOOKUP_TYPE = 'PAYEE_TYPE'
AND B.BENEFIT_LEVEL = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'BENEFIT_LEVEL'
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE
AND B.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN C.EFFECTIVE_START_DATE
AND C.EFFECTIVE_END_DATE UNION ALL SELECT B.ROWID
, B.BENEFICIARY_ID
, O.NAME
, B.SOURCE_ID
, B.SOURCE_TYPE
, S.MEANING
, B.ELEMENT_ENTRY_ID
, B.BENEFIT_LEVEL
, L.MEANING
, B.PROPORTION
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
FROM HR_LOOKUPS L
, HR_LOOKUPS S
, FND_SESSIONS FND
, HR_ORGANIZATION_UNITS O
, BEN_BENEFICIARIES_F B
WHERE B.SOURCE_ID = O.ORGANIZATION_ID
AND B.SOURCE_TYPE = 'O'
AND B.SOURCE_TYPE = S.LOOKUP_CODE
AND S.LOOKUP_TYPE = 'PAYEE_TYPE'
AND B.BENEFIT_LEVEL = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'BENEFIT_LEVEL'
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE
AND B.EFFECTIVE_END_DATE

Columns