View: BEN_COVERED_DEPENDENTS_V

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

View Text

SELECT BCD.ROWID ROW_ID
, BCD.COVERED_DEPENDENT_ID
, C.FULL_NAME
, C.ORDER_NAME
, BCD.CONTACT_RELATIONSHIP_ID
, C.NATIONAL_IDENTIFIER
, CR.PERSON_ID
, HR.MEANING CONTACT_TYPE
, BCD.ELEMENT_ENTRY_ID
, BCD.EFFECTIVE_START_DATE
, BCD.EFFECTIVE_END_DATE
, BCD.LAST_UPDATE_DATE
, BCD.LAST_UPDATED_BY
, BCD.LAST_UPDATE_LOGIN
, BCD.CREATED_BY
, BCD.CREATION_DATE
FROM HR_LOOKUPS HR
, FND_SESSIONS FND
, PER_CONTACT_RELATIONSHIPS CR
, PER_PEOPLE_F C
, BEN_COVERED_DEPENDENTS_F BCD
WHERE BCD.CONTACT_RELATIONSHIP_ID = CR.CONTACT_RELATIONSHIP_ID
AND CR.CONTACT_PERSON_ID = C.PERSON_ID
AND CR.CONTACT_TYPE = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = 'CONTACT'
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN BCD.EFFECTIVE_START_DATE
AND BCD.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN C.EFFECTIVE_START_DATE
AND C.EFFECTIVE_END_DATE

Columns