View: BEN_PL_BNF_D

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

View Text

SELECT PBN.ROWID ROW_ID
, PBN.PL_BNF_ID
, PBN.EFFECTIVE_START_DATE
, PBN.EFFECTIVE_END_DATE
, BNF_PERSON.FULL_NAME BNF_PERSON_FULL_NAME
, ORGANIZATION.NAME ORGANIZATION_NAME
, TTEE_PERSON.FULL_NAME TTEE_PERSON_FULL_NAME
, PRMRY_CNTNGNT.MEANING PRMRY_CNTNGNT_MEANING
, PBN.PCT_DSGD_NUM
, PBN.AMT_DSGD_VAL
, PBN.AMT_DSGD_UOM
, PBN.ADDL_INSTRN_TXT
, PBN.DSGN_STRT_DT
, PBN.DSGN_THRU_DT
, PBN.LAST_UPDATE_DATE
, PBN.LAST_UPDATED_BY
FROM BEN_PL_BNF_F PBN
, BEN_PER_IN_LER PIL
, PER_ALL_PEOPLE_F BNF_PERSON
, PER_ALL_PEOPLE_F TTEE_PERSON
, HR_ALL_ORGANIZATION_UNITS_VL ORGANIZATION
, HR_LOOKUPS PRMRY_CNTNGNT
, FND_USER_VIEW FUSER
WHERE FUSER.USER_ID (+)= PBN.LAST_UPDATED_BY
AND BNF_PERSON.PERSON_ID(+) = PBN.BNF_PERSON_ID
AND PBN.EFFECTIVE_START_DATE BETWEEN BNF_PERSON.EFFECTIVE_START_DATE
AND BNF_PERSON.EFFECTIVE_END_DATE
AND TTEE_PERSON.PERSON_ID(+) = PBN.TTEE_PERSON_ID
AND PBN.EFFECTIVE_START_DATE BETWEEN TTEE_PERSON.EFFECTIVE_START_DATE
AND TTEE_PERSON.EFFECTIVE_END_DATE
AND ORGANIZATION.ORGANIZATION_ID(+) = PBN.ORGANIZATION_ID
AND PRMRY_CNTNGNT.LOOKUP_CODE(+) = PBN.PRMRY_CNTNGNT_CD
AND PRMRY_CNTNGNT.LOOKUP_TYPE(+) = 'BEN_PRMRY_CNTNGNT'
AND PIL.PER_IN_LER_ID(+)=PBN.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID(+)=PBN.BUSINESS_GROUP_ID+0
AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL )

Columns