View: BENBV_PRTT_REIMBMT_RQST_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the details associated with a participant request for reimbursement under a plan.
Implementation/DBA Data:	APPS.BENBV_PRTT_REIMBMT_RQST_V

View Text

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

Columns