VIEW: APPS.BEN_PRTT_REIMBMT_RQST_D

Source

View Text - Preformatted

SELECT prc.ROWID ROW_ID, prc.prtt_reimbmt_rqst_id, prc.effective_start_date, prc.effective_end_date, prc.last_update_date, fuser.user_name, prc.rqst_amt, prc.rqst_num, prc.aprvd_for_pymt_amt, prc.submtd_dt, pln.name, prc.exp_incurd_dt, prc.incrd_to_dt, prc.incrd_from_dt , per.full_name, status_meaning.meaning, adjmt_flag.meaning FROM ben_prtt_reimbmt_rqst_f prc, fnd_user fuser, ben_pl_f pln, hr_lookups adjmt_flag, hr_lookups status_meaning, per_all_people_f per WHERE fuser.user_id(+) = prc.last_updated_by AND pln.pl_id(+)=prc.pl_id AND adjmt_flag.lookup_code(+) = prc.adjmt_flag AND adjmt_flag.lookup_type(+) = 'YES_NO' AND status_meaning.lookup_code(+)=prc.prtt_reimbmt_rqst_stat_cd AND status_meaning.lookup_type(+) = 'BEN_REIMBMT_RQST_STAT' AND per.person_id(+)=prc.recipient_person_id and prc.effective_start_date BETWEEN pln.effective_start_date (+) and pln.effective_end_date(+) and prc.effective_start_date BETWEEN per.effective_start_date (+) and per.effective_end_date(+)

View Text - HTML Formatted

SELECT PRC.ROWID ROW_ID
, PRC.PRTT_REIMBMT_RQST_ID
, PRC.EFFECTIVE_START_DATE
, PRC.EFFECTIVE_END_DATE
, PRC.LAST_UPDATE_DATE
, FUSER.USER_NAME
, PRC.RQST_AMT
, PRC.RQST_NUM
, PRC.APRVD_FOR_PYMT_AMT
, PRC.SUBMTD_DT
, PLN.NAME
, PRC.EXP_INCURD_DT
, PRC.INCRD_TO_DT
, PRC.INCRD_FROM_DT
, PER.FULL_NAME
, STATUS_MEANING.MEANING
, ADJMT_FLAG.MEANING
FROM BEN_PRTT_REIMBMT_RQST_F PRC
, FND_USER FUSER
, BEN_PL_F PLN
, HR_LOOKUPS ADJMT_FLAG
, HR_LOOKUPS STATUS_MEANING
, PER_ALL_PEOPLE_F PER
WHERE FUSER.USER_ID(+) = PRC.LAST_UPDATED_BY
AND PLN.PL_ID(+)=PRC.PL_ID
AND ADJMT_FLAG.LOOKUP_CODE(+) = PRC.ADJMT_FLAG
AND ADJMT_FLAG.LOOKUP_TYPE(+) = 'YES_NO'
AND STATUS_MEANING.LOOKUP_CODE(+)=PRC.PRTT_REIMBMT_RQST_STAT_CD
AND STATUS_MEANING.LOOKUP_TYPE(+) = 'BEN_REIMBMT_RQST_STAT'
AND PER.PERSON_ID(+)=PRC.RECIPIENT_PERSON_ID
AND PRC.EFFECTIVE_START_DATE BETWEEN PLN.EFFECTIVE_START_DATE (+)
AND PLN.EFFECTIVE_END_DATE(+)
AND PRC.EFFECTIVE_START_DATE BETWEEN PER.EFFECTIVE_START_DATE (+)
AND PER.EFFECTIVE_END_DATE(+)