VIEW: APPS.BEN_COVERED_DEPENDENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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