Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PRTT_RMT_RQST_CTFN_PRVDD_D |
SELECT PQC.ROWID ROW_ID
, PQC.PRTT_RMT_RQST_CTFN_PRVDD_ID
, PQC.PRTT_CLM_GD_OR_SVC_TYP_ID
, PQC.PL_GD_R_SVC_CTFN_ID
, PQC.EFFECTIVE_START_DATE
, PQC.EFFECTIVE_END_DATE
, PQC.REIMBMT_CTFN_RQD_FLAG
, PQC.BUSINESS_GROUP_ID
, PQC.PRTT_ENRT_ACTN_ID
, PQC.REIMBMT_CTFN_RECD_DT
, PQC.REIMBMT_CTFN_DND_DT
, PQC.REIMBMT_CTFN_TYP_CD
, PQC.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PRTT_RMT_RQST_CTFN_PRVDD_F PQC
, FND_USER FUSER
WHERE FUSER.USER_ID(+)= PQC.LAST_UPDATED_BY