VIEW: APPS.BEN_BENEFICIARIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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