VIEW: APPS.PER_COBRA_DEPENDENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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