VIEW: APPS.BENBV_PL_R_OIPL_PREM_BY_MO_V

Source

View Text - Preformatted

SELECT PBM.EFFECTIVE_START_DATE, PBM.EFFECTIVE_END_DATE, PBM.PROGRAM_UPDATE_DATE, PBM.MO_NUM, PBM.YR_NUM, PBM.VAL, PBM.UOM, PBM.PRTTS_NUM, /* descriptive flexfield */ '_DF:BEN:BEN_PL_R_OIPL_PREM_BY_MO_F:PBM', PBM.MNL_ADJ_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PBM.MNL_ADJ_FLAG), /* id columns */ PBM.PL_R_OIPL_PREM_BY_MO_ID, PBM.ACTL_PREM_ID, PBM.BUSINESS_GROUP_ID, PBM.COST_ALLOCATION_KEYFLEX_ID, PBM.REQUEST_ID, PBM.PROGRAM_ID, PBM.PROGRAM_APPLICATION_ID, /* who columns */ PBM.LAST_UPDATE_DATE, PBM.LAST_UPDATED_BY, PBM.CREATED_BY, PBM.CREATION_DATE FROM BEN_PL_R_OIPL_PREM_BY_MO_F PBM WHERE PBM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PBM.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PBM.EFFECTIVE_START_DATE
, PBM.EFFECTIVE_END_DATE
, PBM.PROGRAM_UPDATE_DATE
, PBM.MO_NUM
, PBM.YR_NUM
, PBM.VAL
, PBM.UOM
, PBM.PRTTS_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PL_R_OIPL_PREM_BY_MO_F:PBM'
, PBM.MNL_ADJ_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PBM.MNL_ADJ_FLAG)
, /* ID COLUMNS */ PBM.PL_R_OIPL_PREM_BY_MO_ID
, PBM.ACTL_PREM_ID
, PBM.BUSINESS_GROUP_ID
, PBM.COST_ALLOCATION_KEYFLEX_ID
, PBM.REQUEST_ID
, PBM.PROGRAM_ID
, PBM.PROGRAM_APPLICATION_ID
, /* WHO COLUMNS */ PBM.LAST_UPDATE_DATE
, PBM.LAST_UPDATED_BY
, PBM.CREATED_BY
, PBM.CREATION_DATE
FROM BEN_PL_R_OIPL_PREM_BY_MO_F PBM
WHERE PBM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBM.BUSINESS_GROUP_ID) WITH READ ONLY