VIEW: APPS.BENBV_PER_CM_PRVDD_V

Source

View Text - Preformatted

SELECT PCD.EFFECTIVE_START_DATE, PCD.EFFECTIVE_END_DATE, PCD.PROGRAM_UPDATE_DATE, PCD.SENT_DT, PCD.INSTNC_NUM, PCD.TO_BE_SENT_DT, PCD.DLVRY_INSTN_TXT, PCD.RESND_CMNT_TXT, /* descriptive flexfield */ '_DF:BEN:BEN_PER_CM_PRVDD_F:PCD', /* codes */ PCD.PER_CM_PRVDD_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_CM_PRVDD_STAT',PCD.PER_CM_PRVDD_STAT_CD), PCD.CM_DLVRY_MED_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_DLVRY_MED',PCD.CM_DLVRY_MED_CD), PCD.CM_DLVRY_MTHD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_DLVRY_MTHD',PCD.CM_DLVRY_MTHD_CD), PCD.RESND_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RESND_RSN',PCD.RESND_RSN_CD), PCD.RQSTD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PCD.RQSTD_FLAG), PCD.INSPN_RQD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PCD.INSPN_RQD_FLAG), /* id columns */ PCD.PER_CM_PRVDD_ID, PCD.PER_CM_ID, PCD.BUSINESS_GROUP_ID, PCD.REQUEST_ID, PCD.PROGRAM_APPLICATION_ID, PCD.PROGRAM_ID, PCD.ADDRESS_ID, /* who columns */ PCD.LAST_UPDATE_DATE, PCD.LAST_UPDATED_BY, PCD.CREATED_BY, PCD.CREATION_DATE FROM BEN_PER_CM_PRVDD_F PCD WHERE PCD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PCD.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PCD.EFFECTIVE_START_DATE
, PCD.EFFECTIVE_END_DATE
, PCD.PROGRAM_UPDATE_DATE
, PCD.SENT_DT
, PCD.INSTNC_NUM
, PCD.TO_BE_SENT_DT
, PCD.DLVRY_INSTN_TXT
, PCD.RESND_CMNT_TXT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PER_CM_PRVDD_F:PCD'
, /* CODES */ PCD.PER_CM_PRVDD_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_CM_PRVDD_STAT'
, PCD.PER_CM_PRVDD_STAT_CD)
, PCD.CM_DLVRY_MED_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DLVRY_MED'
, PCD.CM_DLVRY_MED_CD)
, PCD.CM_DLVRY_MTHD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DLVRY_MTHD'
, PCD.CM_DLVRY_MTHD_CD)
, PCD.RESND_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RESND_RSN'
, PCD.RESND_RSN_CD)
, PCD.RQSTD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PCD.RQSTD_FLAG)
, PCD.INSPN_RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PCD.INSPN_RQD_FLAG)
, /* ID COLUMNS */ PCD.PER_CM_PRVDD_ID
, PCD.PER_CM_ID
, PCD.BUSINESS_GROUP_ID
, PCD.REQUEST_ID
, PCD.PROGRAM_APPLICATION_ID
, PCD.PROGRAM_ID
, PCD.ADDRESS_ID
, /* WHO COLUMNS */ PCD.LAST_UPDATE_DATE
, PCD.LAST_UPDATED_BY
, PCD.CREATED_BY
, PCD.CREATION_DATE
FROM BEN_PER_CM_PRVDD_F PCD
WHERE PCD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PCD.BUSINESS_GROUP_ID) WITH READ ONLY