VIEW: APPS.BENBV_PRTT_REIMBMT_RQST_V

Source

View Text - Preformatted

SELECT PRC.EFFECTIVE_START_DATE, PRC.EFFECTIVE_END_DATE, PRC.INCRD_FROM_DT, PRC.INCRD_TO_DT, PRC.RQST_NUM, PRC.RQST_AMT, PRC.RQST_AMT_UOM, PRC.RQST_BTCH_NUM, PRC.STAT_PRR_TO_OVRD, HR_BIS.BIS_DECODE_LOOKUP('BEN_REIMBMT_RQST_STAT',PRC.STAT_PRR_TO_OVRD), PRC.PYMT_STAT_PRR_TO_OVRD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PYMT_STAT',PRC.PYMT_STAT_PRR_TO_OVRD), PRC.SUBMTD_DT, PRC.TTL_RQST_AMT, PRC.APRVD_FOR_PYMT_AMT, PRC.EXP_INCURD_DT, /* descriptive flexfield */ '_DF:BEN:BEN_PRTT_REIMBMT_RQST_F:PRC', /* codes */ PRC.PRTT_REIMBMT_RQST_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_REIMBMT_RQST_STAT',PRC.PRTT_REIMBMT_RQST_STAT_CD), PRC.REIMBMT_CTFN_TYP_PRVDD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RMBMT_CTFN_TYP',PRC.REIMBMT_CTFN_TYP_PRVDD_CD), PRC.RCRRG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_REIMBMT_RQST_RCRG',PRC.RCRRG_CD), PRC.STAT_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT_RSN',PRC.STAT_RSN_CD), PRC.PYMT_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PYMT_STAT',PRC.PYMT_STAT_CD), PRC.PYMT_STAT_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PYMT_STAT_RSN',PRC.PYMT_STAT_RSN_CD), PRC.STAT_OVRDN_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT_OVRDN_RSN',PRC.STAT_OVRDN_RSN_CD), PRC.PYMT_STAT_OVRDN_RSN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PYMT_STAT_OVRDN_RSN',PRC.PYMT_STAT_OVRDN_RSN_CD), PRC.STAT_OVRDN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PRC.STAT_OVRDN_FLAG), PRC.PYMT_STAT_OVRDN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PRC.PYMT_STAT_OVRDN_FLAG), PRC.ADJMT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PRC.ADJMT_FLAG), /* id columns */ PRC.PRTT_REIMBMT_RQST_ID, PRC.BUSINESS_GROUP_ID, PRC.PL_ID, PRC.SUBMITTER_PERSON_ID, PRC.PROVIDER_PERSON_ID, PRC.GD_OR_SVC_TYP_ID, PRC.RECIPIENT_PERSON_ID, PRC.PROVIDER_SSN_PERSON_ID, PRC.CONTACT_RELATIONSHIP_ID, PRC.PRTT_ENRT_RSLT_ID, PRC.COMMENT_ID, /* who columns */ PRC.LAST_UPDATE_DATE, PRC.LAST_UPDATED_BY, PRC.CREATED_BY, PRC.CREATION_DATE FROM BEN_PRTT_REIMBMT_RQST_F PRC WHERE PRC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PRC.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PRC.EFFECTIVE_START_DATE
, PRC.EFFECTIVE_END_DATE
, PRC.INCRD_FROM_DT
, PRC.INCRD_TO_DT
, PRC.RQST_NUM
, PRC.RQST_AMT
, PRC.RQST_AMT_UOM
, PRC.RQST_BTCH_NUM
, PRC.STAT_PRR_TO_OVRD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_REIMBMT_RQST_STAT'
, PRC.STAT_PRR_TO_OVRD)
, PRC.PYMT_STAT_PRR_TO_OVRD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PYMT_STAT'
, PRC.PYMT_STAT_PRR_TO_OVRD)
, PRC.SUBMTD_DT
, PRC.TTL_RQST_AMT
, PRC.APRVD_FOR_PYMT_AMT
, PRC.EXP_INCURD_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PRTT_REIMBMT_RQST_F:PRC'
, /* CODES */ PRC.PRTT_REIMBMT_RQST_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_REIMBMT_RQST_STAT'
, PRC.PRTT_REIMBMT_RQST_STAT_CD)
, PRC.REIMBMT_CTFN_TYP_PRVDD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RMBMT_CTFN_TYP'
, PRC.REIMBMT_CTFN_TYP_PRVDD_CD)
, PRC.RCRRG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_REIMBMT_RQST_RCRG'
, PRC.RCRRG_CD)
, PRC.STAT_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT_RSN'
, PRC.STAT_RSN_CD)
, PRC.PYMT_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PYMT_STAT'
, PRC.PYMT_STAT_CD)
, PRC.PYMT_STAT_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PYMT_STAT_RSN'
, PRC.PYMT_STAT_RSN_CD)
, PRC.STAT_OVRDN_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT_OVRDN_RSN'
, PRC.STAT_OVRDN_RSN_CD)
, PRC.PYMT_STAT_OVRDN_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PYMT_STAT_OVRDN_RSN'
, PRC.PYMT_STAT_OVRDN_RSN_CD)
, PRC.STAT_OVRDN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRC.STAT_OVRDN_FLAG)
, PRC.PYMT_STAT_OVRDN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRC.PYMT_STAT_OVRDN_FLAG)
, PRC.ADJMT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRC.ADJMT_FLAG)
, /* ID COLUMNS */ PRC.PRTT_REIMBMT_RQST_ID
, PRC.BUSINESS_GROUP_ID
, PRC.PL_ID
, PRC.SUBMITTER_PERSON_ID
, PRC.PROVIDER_PERSON_ID
, PRC.GD_OR_SVC_TYP_ID
, PRC.RECIPIENT_PERSON_ID
, PRC.PROVIDER_SSN_PERSON_ID
, PRC.CONTACT_RELATIONSHIP_ID
, PRC.PRTT_ENRT_RSLT_ID
, PRC.COMMENT_ID
, /* WHO COLUMNS */ PRC.LAST_UPDATE_DATE
, PRC.LAST_UPDATED_BY
, PRC.CREATED_BY
, PRC.CREATION_DATE
FROM BEN_PRTT_REIMBMT_RQST_F PRC
WHERE PRC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PRC.BUSINESS_GROUP_ID) WITH READ ONLY