VIEW: APPS.BENBV_PRTT_PREM_BY_MO_V

Source

View Text - Preformatted

SELECT PRM.EFFECTIVE_START_DATE, PRM.EFFECTIVE_END_DATE, PRM.PROGRAM_UPDATE_DATE, PRM.MO_NUM, PRM.YR_NUM, PRM.ANTCPD_PRTT_CNTR_UOM, PRM.ANTCPD_PRTT_CNTR_VAL, PRM.VAL, PRM.CR_VAL, PRM.UOM, /* descriptive flexfield */ '_DF:BEN:BEN_PRTT_PREM_BY_MO_F:PRM', PRM.MNL_ADJ_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PRM.MNL_ADJ_FLAG), PRM.CR_MNL_ADJ_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PRM.CR_MNL_ADJ_FLAG), PRM.ALCTD_VAL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PRM.ALCTD_VAL_FLAG), /* id columns */ PRM.PRTT_PREM_BY_MO_ID, PRM.PRTT_PREM_ID, PRM.BUSINESS_GROUP_ID, PRM.REQUEST_ID, PRM.PROGRAM_APPLICATION_ID, PRM.PROGRAM_ID, PRM.COST_ALLOCATION_KEYFLEX_ID, /* who columns */ PRM.LAST_UPDATE_DATE, PRM.LAST_UPDATED_BY, PRM.CREATED_BY, PRM.CREATION_DATE FROM BEN_PRTT_PREM_BY_MO_F PRM WHERE PRM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PRM.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PRM.EFFECTIVE_START_DATE
, PRM.EFFECTIVE_END_DATE
, PRM.PROGRAM_UPDATE_DATE
, PRM.MO_NUM
, PRM.YR_NUM
, PRM.ANTCPD_PRTT_CNTR_UOM
, PRM.ANTCPD_PRTT_CNTR_VAL
, PRM.VAL
, PRM.CR_VAL
, PRM.UOM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PRTT_PREM_BY_MO_F:PRM'
, PRM.MNL_ADJ_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRM.MNL_ADJ_FLAG)
, PRM.CR_MNL_ADJ_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRM.CR_MNL_ADJ_FLAG)
, PRM.ALCTD_VAL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRM.ALCTD_VAL_FLAG)
, /* ID COLUMNS */ PRM.PRTT_PREM_BY_MO_ID
, PRM.PRTT_PREM_ID
, PRM.BUSINESS_GROUP_ID
, PRM.REQUEST_ID
, PRM.PROGRAM_APPLICATION_ID
, PRM.PROGRAM_ID
, PRM.COST_ALLOCATION_KEYFLEX_ID
, /* WHO COLUMNS */ PRM.LAST_UPDATE_DATE
, PRM.LAST_UPDATED_BY
, PRM.CREATED_BY
, PRM.CREATION_DATE
FROM BEN_PRTT_PREM_BY_MO_F PRM
WHERE PRM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PRM.BUSINESS_GROUP_ID) WITH READ ONLY