View: PER_COBRA_DEPENDENTS_V

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

View Text

SELECT DEP.ROWID ROW_ID
, DEP.COBRA_DEPENDENT_ID
, DEP.COBRA_COVERAGE_ENROLLMENT_ID
, DEP.CONTACT_RELATIONSHIP_ID
, HR.MEANING RELATIONSHIP
, PPF.FULL_NAME
, DEP.EFFECTIVE_START_DATE
, DEP.EFFECTIVE_END_DATE
, DEP.OBJECT_VERSION_NUMBER
, DEP.ATTRIBUTE_CATEGORY
, DEP.ATTRIBUTE1
, DEP.ATTRIBUTE2
, DEP.ATTRIBUTE3
, DEP.ATTRIBUTE4
, DEP.ATTRIBUTE5
, DEP.ATTRIBUTE6
, DEP.ATTRIBUTE7
, DEP.ATTRIBUTE8
, DEP.ATTRIBUTE9
, DEP.ATTRIBUTE10
, DEP.ATTRIBUTE11
, DEP.ATTRIBUTE12
, DEP.ATTRIBUTE13
, DEP.ATTRIBUTE14
, DEP.ATTRIBUTE15
, DEP.ATTRIBUTE16
, DEP.ATTRIBUTE17
, DEP.ATTRIBUTE18
, DEP.ATTRIBUTE19
, DEP.ATTRIBUTE20
FROM PER_COBRA_DEPENDENTS_F DEP
, PER_CONTACT_RELATIONSHIPS REP
, HR_LOOKUPS HR
, PER_PEOPLE_F PPF
, FND_SESSIONS FND
WHERE DEP.CONTACT_RELATIONSHIP_ID = REP.CONTACT_RELATIONSHIP_ID
AND REP.CONTACT_TYPE = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = 'CONTACT'
AND REP.CONTACT_PERSON_ID = PPF.PERSON_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN DEP.EFFECTIVE_START_DATE
AND DEP.EFFECTIVE_END_DATE

Columns