VIEW: APPS.PAY_IE_SOCIAL_BENEFITS_V

Source

View Text - Preformatted

SELECT psb.rowid, psb.SOCIAL_BENEFIT_ID , psb.EFFECTIVE_START_DATE, psb.EFFECTIVE_END_DATE, psb.OBJECT_VERSION_NUMBER, psb.ASSIGNMENT_ID, psb.ABSENCE_START_DATE, psb.ABSENCE_END_DATE, psb.BENEFIT_AMOUNT, psb.BENEFIT_TYPE, SUBSTR(hr_general.decode_lookup('IE_BENEFIT_TYPE', psb.benefit_type), 1, 80) D_BENEFIT_TYPE, psb.CALCULATION_OPTION, SUBSTR(hr_general.decode_lookup('IE_CALC_OPTION', psb.calculation_option), 1, 80) D_CALCULATION_OPTION, psb.REDUCED_TAX_CREDIT, psb.REDUCED_STANDARD_CUTOFF, psb.INCIDENT_ID, pwi.INCIDENT_REFERENCE, pwi.INCIDENT_DATE, pwi.INCIDENT_TYPE, SUBSTR(hr_general.decode_lookup('INCIDENT_TYPE', pwi.incident_type), 1, 80) D_INCIDENT_TYPE, psb.CREATED_BY, psb.CREATION_DATE, psb.LAST_UPDATED_BY, psb.LAST_UPDATE_DATE, psb.LAST_UPDATE_LOGIN, psb.REQUEST_ID, psb.PROGRAM_APPLICATION_ID, psb.PROGRAM_ID, psb.PROGRAM_UPDATE_DATE FROM PAY_IE_SOCIAL_BENEFITS_F psb , FND_SESSIONS fs , PER_WORK_INCIDENTS pwi WHERE fs.session_id = userenv('SESSIONID') AND fs.EFFECTIVE_DATE BETWEEN psb.effective_start_date AND effective_end_date AND psb.incident_id = pwi.incident_id (+)

View Text - HTML Formatted

SELECT PSB.ROWID
, PSB.SOCIAL_BENEFIT_ID
, PSB.EFFECTIVE_START_DATE
, PSB.EFFECTIVE_END_DATE
, PSB.OBJECT_VERSION_NUMBER
, PSB.ASSIGNMENT_ID
, PSB.ABSENCE_START_DATE
, PSB.ABSENCE_END_DATE
, PSB.BENEFIT_AMOUNT
, PSB.BENEFIT_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_BENEFIT_TYPE'
, PSB.BENEFIT_TYPE)
, 1
, 80) D_BENEFIT_TYPE
, PSB.CALCULATION_OPTION
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_CALC_OPTION'
, PSB.CALCULATION_OPTION)
, 1
, 80) D_CALCULATION_OPTION
, PSB.REDUCED_TAX_CREDIT
, PSB.REDUCED_STANDARD_CUTOFF
, PSB.INCIDENT_ID
, PWI.INCIDENT_REFERENCE
, PWI.INCIDENT_DATE
, PWI.INCIDENT_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('INCIDENT_TYPE'
, PWI.INCIDENT_TYPE)
, 1
, 80) D_INCIDENT_TYPE
, PSB.CREATED_BY
, PSB.CREATION_DATE
, PSB.LAST_UPDATED_BY
, PSB.LAST_UPDATE_DATE
, PSB.LAST_UPDATE_LOGIN
, PSB.REQUEST_ID
, PSB.PROGRAM_APPLICATION_ID
, PSB.PROGRAM_ID
, PSB.PROGRAM_UPDATE_DATE
FROM PAY_IE_SOCIAL_BENEFITS_F PSB
, FND_SESSIONS FS
, PER_WORK_INCIDENTS PWI
WHERE FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN PSB.EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
AND PSB.INCIDENT_ID = PWI.INCIDENT_ID (+)