View: BEN_COMP_OBJ_ABR_LVL_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_COMP_OBJ_ABR_LVL_V

View Text

SELECT PLN.NAME
, NULL
, NULL
, PLN.PL_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PLN.BUSINESS_GROUP_ID
FROM BEN_PL_F PLN
, FND_SESSIONS FND
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PLN.EFFECTIVE_START_DATE
AND PLN.EFFECTIVE_END_DATE UNION /* OIPL LEVEL */ SELECT PLN.NAME
, OPT.NAME
, NULL
, TO_NUMBER(NULL)
, OIPL.OIPL_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, OIPL.BUSINESS_GROUP_ID
FROM BEN_OIPL_F OIPL
, BEN_PL_F PLN
, BEN_OPT_F OPT
, FND_SESSIONS FND
WHERE OIPL.PL_ID = PLN.PL_ID
AND OIPL.OPT_ID = OPT.OPT_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN OIPL.EFFECTIVE_START_DATE
AND OIPL.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN PLN.EFFECTIVE_START_DATE
AND PLN.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN OPT.EFFECTIVE_START_DATE
AND OPT.EFFECTIVE_END_DATE UNION /* OIPLIP LEVEL */ SELECT PLN.NAME
, OPT.NAME
, PGM.NAME
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, OIPLIP.OIPLIP_ID
, TO_NUMBER(NULL)
, OIPLIP.BUSINESS_GROUP_ID
FROM BEN_OIPLIP_F OIPLIP
, BEN_OIPL_F OIPL
, BEN_PLIP_F PLIP
, BEN_PL_F PLN
, BEN_OPT_F OPT
, BEN_PGM_F PGM
, FND_SESSIONS FND
WHERE OIPLIP.OIPL_ID = OIPL.OIPL_ID
AND OIPLIP.PLIP_ID = PLIP.PLIP_ID
AND OIPL.PL_ID = PLN.PL_ID
AND PLIP.PL_ID = PLN.PL_ID
AND OIPL.OPT_ID = OPT.OPT_ID
AND PLIP.PGM_ID = PGM.PGM_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN OIPLIP.EFFECTIVE_START_DATE
AND OIPLIP.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN OIPL.EFFECTIVE_START_DATE
AND OIPL.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN PLIP.EFFECTIVE_START_DATE
AND PLIP.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN PLN.EFFECTIVE_START_DATE
AND PLN.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN OPT.EFFECTIVE_START_DATE
AND OPT.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN PGM.EFFECTIVE_START_DATE
AND PGM.EFFECTIVE_END_DATE UNION /* PLIP LEVEL */ SELECT PLN.NAME
, NULL
, PGM.NAME
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PLIP.PLIP_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PLIP.BUSINESS_GROUP_ID
FROM BEN_PLIP_F PLIP
, BEN_PL_F PLN
, BEN_PGM_F PGM
, FND_SESSIONS FND
WHERE PLIP.PL_ID = PLN.PL_ID
AND PLIP.PGM_ID = PGM.PGM_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PLIP.EFFECTIVE_START_DATE
AND PLIP.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN PLN.EFFECTIVE_START_DATE
AND PLN.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN PGM.EFFECTIVE_START_DATE
AND PGM.EFFECTIVE_END_DATE UNION /* OPTION LEVEL */ SELECT NULL
, OPT.NAME
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, OPT.OPT_ID
, OPT.BUSINESS_GROUP_ID
FROM BEN_OPT_F OPT
, FND_SESSIONS FND
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN OPT.EFFECTIVE_START_DATE
AND OPT.EFFECTIVE_END_DATE

Columns