Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the participant reimbursement requests which have been approved for payment. |
Implementation/DBA Data: | APPS.BENBV_PRTT_RMT_APRVD_FR_PYMT_V |
SELECT PRY.EFFECTIVE_START_DATE
, PRY.EFFECTIVE_END_DATE
, PRY.APPRVD_FR_PYMT_NUM
, PRY.APRVD_FR_PYMT_AMT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PRTT_RMT_APRVD_FR_PYMT_F:PRY'
, /* CODES */ PRY.PYMT_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_APRVD_PYMT_STAT'
, PRY.PYMT_STAT_CD)
, PRY.PYMT_STAT_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_APRVD_PYMT_STAT_RSN'
, PRY.PYMT_STAT_RSN_CD)
, PRY.PYMT_STAT_OVRDN_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PYMT_STAT_OVRDN_RSN'
, PRY.PYMT_STAT_OVRDN_RSN_CD)
, PRY.PYMT_STAT_PRR_TO_OVRD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PYMT_STAT_OVRDN_RSN'
, PRY.PYMT_STAT_PRR_TO_OVRD_CD)
, PRY.ADJMT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRY.ADJMT_FLAG)
, /* ID COLUMNS */ PRY.PRTT_RMT_APRVD_FR_PYMT_ID
, PRY.PRTT_REIMBMT_RQST_ID
, PRY.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ PRY.LAST_UPDATE_DATE
, PRY.LAST_UPDATED_BY
, PRY.CREATED_BY
, PRY.CREATION_DATE
FROM BEN_PRTT_RMT_APRVD_FR_PYMT_F PRY
WHERE PRY.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PRY.BUSINESS_GROUP_ID) WITH READ ONLY