VIEW: APPS.BENBV_PL_BNF_V

Source

View Text - Preformatted

SELECT PBN.EFFECTIVE_START_DATE, PBN.EFFECTIVE_END_DATE, PBN.PROGRAM_UPDATE_DATE, PBN.PCT_DSGD_NUM, PBN.AMT_DSGD_VAL, PBN.AMT_DSGD_UOM, PBN.ADDL_INSTRN_TXT, PBN.DSGN_THRU_DT, PBN.DSGN_STRT_DT, /* descriptive flexfield */ '_DF:BEN:BEN_PL_BNF_F:PBN', /* codes */ PBN.PRMRY_CNTNGNT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRMRY_CNTNGNT',PBN.PRMRY_CNTNGNT_CD), /* id columns */ PBN.PL_BNF_ID, PBN.BUSINESS_GROUP_ID, PBN.PRTT_ENRT_RSLT_ID, PBN.PER_IN_LER_ID, PBN.REQUEST_ID, PBN.PROGRAM_APPLICATION_ID, PBN.PROGRAM_ID, PBN.ORGANIZATION_ID, PBN.BNF_PERSON_ID, PBN.TTEE_PERSON_ID, /* who columns */ PBN.LAST_UPDATE_DATE, PBN.LAST_UPDATED_BY, PBN.CREATED_BY, PBN.CREATION_DATE FROM BEN_PL_BNF_F PBN WHERE PBN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PBN.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PBN.EFFECTIVE_START_DATE
, PBN.EFFECTIVE_END_DATE
, PBN.PROGRAM_UPDATE_DATE
, PBN.PCT_DSGD_NUM
, PBN.AMT_DSGD_VAL
, PBN.AMT_DSGD_UOM
, PBN.ADDL_INSTRN_TXT
, PBN.DSGN_THRU_DT
, PBN.DSGN_STRT_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PL_BNF_F:PBN'
, /* CODES */ PBN.PRMRY_CNTNGNT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRMRY_CNTNGNT'
, PBN.PRMRY_CNTNGNT_CD)
, /* ID COLUMNS */ PBN.PL_BNF_ID
, PBN.BUSINESS_GROUP_ID
, PBN.PRTT_ENRT_RSLT_ID
, PBN.PER_IN_LER_ID
, PBN.REQUEST_ID
, PBN.PROGRAM_APPLICATION_ID
, PBN.PROGRAM_ID
, PBN.ORGANIZATION_ID
, PBN.BNF_PERSON_ID
, PBN.TTEE_PERSON_ID
, /* WHO COLUMNS */ PBN.LAST_UPDATE_DATE
, PBN.LAST_UPDATED_BY
, PBN.CREATED_BY
, PBN.CREATION_DATE
FROM BEN_PL_BNF_F PBN
WHERE PBN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBN.BUSINESS_GROUP_ID) WITH READ ONLY