VIEW: APPS.BENBV_ACTL_PREM_V

Source

View Text - Preformatted

SELECT APR.EFFECTIVE_START_DATE, APR.EFFECTIVE_END_DATE, APR.NAME, APR.UOM, APR.PRTL_MO_DET_MTHD_RL, APR.WSH_RL_DY_MO_NUM, APR.VAL, APR.RNDG_RL, APR.VAL_CALC_RL, APR.CR_LKBK_VAL, APR.CR_LKBK_UOM, APR.UPR_LMT_VAL, APR.UPR_LMT_CALC_RL, APR.LWR_LMT_VAL, APR.LWR_LMT_CALC_RL, APR.VRBL_RT_ADD_ON_CALC_RL, CASE WHEN (APR.PL_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PL_NAME(APR.PL_ID,APR.BUSINESS_GROUP_ID,APR.EFFECTIVE_START_DATE) WHEN (APR.OIPL_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_OIPL_NAME(APR.OIPL_ID,APR.BUSINESS_GROUP_ID,APR.EFFECTIVE_START_DATE) ELSE NULL END COMP_OBJECT, /* descriptive flexfield */ '_DF:BEN:BEN_ACTL_PREM_F:APR', /* codes */ APR.ACTY_REF_PERD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_REF_PERD',APR.ACTY_REF_PERD_CD), APR.PRTL_MO_DET_MTHD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTL_MO_DET_MTHD',APR.PRTL_MO_DET_MTHD_CD), APR.RT_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_TYP',APR.RT_TYP_CD), APR.BNFT_RT_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFT_RT_TYP',APR.BNFT_RT_TYP_CD), APR.MLT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTL_PREM_MLT',APR.MLT_CD), APR.PRDCT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRDCT',APR.PRDCT_CD), APR.RNDG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG',APR.RNDG_CD), APR.PREM_ASNMT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PREM_ASNMT',APR.PREM_ASNMT_CD), APR.PREM_ASNMT_LVL_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PREM_ASNMT_LVL',APR.PREM_ASNMT_LVL_CD), APR.ACTL_PREM_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PREM_TYP',APR.ACTL_PREM_TYP_CD), APR.PREM_PYR_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PREM_PYR',APR.PREM_PYR_CD), APR.PRSPTV_R_RTSPTV_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRSPCTV_R_RTSPCTV',APR.PRSPTV_R_RTSPTV_CD), APR.CR_LKBK_CRNT_PY_ONLY_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',APR.CR_LKBK_CRNT_PY_ONLY_FLAG), /* id columns */ APR.ACTL_PREM_ID, APR.BUSINESS_GROUP_ID, APR.COST_ALLOCATION_KEYFLEX_ID, APR.ORGANIZATION_ID, APR.OIPL_ID, APR.PL_ID, APR.COMP_LVL_FCTR_ID, /* who columns */ APR.LAST_UPDATE_DATE, APR.LAST_UPDATED_BY, APR.CREATED_BY, APR.CREATION_DATE FROM BEN_ACTL_PREM_F APR WHERE APR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, APR.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT APR.EFFECTIVE_START_DATE
, APR.EFFECTIVE_END_DATE
, APR.NAME
, APR.UOM
, APR.PRTL_MO_DET_MTHD_RL
, APR.WSH_RL_DY_MO_NUM
, APR.VAL
, APR.RNDG_RL
, APR.VAL_CALC_RL
, APR.CR_LKBK_VAL
, APR.CR_LKBK_UOM
, APR.UPR_LMT_VAL
, APR.UPR_LMT_CALC_RL
, APR.LWR_LMT_VAL
, APR.LWR_LMT_CALC_RL
, APR.VRBL_RT_ADD_ON_CALC_RL
, CASE WHEN (APR.PL_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PL_NAME(APR.PL_ID
, APR.BUSINESS_GROUP_ID
, APR.EFFECTIVE_START_DATE) WHEN (APR.OIPL_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_OIPL_NAME(APR.OIPL_ID
, APR.BUSINESS_GROUP_ID
, APR.EFFECTIVE_START_DATE) ELSE NULL END COMP_OBJECT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ACTL_PREM_F:APR'
, /* CODES */ APR.ACTY_REF_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_REF_PERD'
, APR.ACTY_REF_PERD_CD)
, APR.PRTL_MO_DET_MTHD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTL_MO_DET_MTHD'
, APR.PRTL_MO_DET_MTHD_CD)
, APR.RT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_TYP'
, APR.RT_TYP_CD)
, APR.BNFT_RT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFT_RT_TYP'
, APR.BNFT_RT_TYP_CD)
, APR.MLT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTL_PREM_MLT'
, APR.MLT_CD)
, APR.PRDCT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRDCT'
, APR.PRDCT_CD)
, APR.RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, APR.RNDG_CD)
, APR.PREM_ASNMT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PREM_ASNMT'
, APR.PREM_ASNMT_CD)
, APR.PREM_ASNMT_LVL_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PREM_ASNMT_LVL'
, APR.PREM_ASNMT_LVL_CD)
, APR.ACTL_PREM_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PREM_TYP'
, APR.ACTL_PREM_TYP_CD)
, APR.PREM_PYR_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PREM_PYR'
, APR.PREM_PYR_CD)
, APR.PRSPTV_R_RTSPTV_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRSPCTV_R_RTSPCTV'
, APR.PRSPTV_R_RTSPTV_CD)
, APR.CR_LKBK_CRNT_PY_ONLY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, APR.CR_LKBK_CRNT_PY_ONLY_FLAG)
, /* ID COLUMNS */ APR.ACTL_PREM_ID
, APR.BUSINESS_GROUP_ID
, APR.COST_ALLOCATION_KEYFLEX_ID
, APR.ORGANIZATION_ID
, APR.OIPL_ID
, APR.PL_ID
, APR.COMP_LVL_FCTR_ID
, /* WHO COLUMNS */ APR.LAST_UPDATE_DATE
, APR.LAST_UPDATED_BY
, APR.CREATED_BY
, APR.CREATION_DATE
FROM BEN_ACTL_PREM_F APR
WHERE APR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, APR.BUSINESS_GROUP_ID) WITH READ ONLY