Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the actual premium amount calculated for a participant for each month that a premium is owed to a carrier providing benefits to a plan or option in plan. |
Implementation/DBA Data: | APPS.BENBV_PRTT_PREM_BY_MO_V |
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