VIEW: APPS.HRBV_ESTABLISHMENT_ATTENDANC_V

Source

View Text - Preformatted

SELECT ESA.ATTENDED_START_DATE, ESA.FULL_TIME, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ESA.FULL_TIME), ESA.ATTENDED_END_DATE, ESA.ESTABLISHMENT, ESA.ADDRESS, '_DF:PER:PER_ESTABLISHMENT_ATTENDANCES:ESA', ESA.ATTENDANCE_ID, ESA.PERSON_ID, ESA.ESTABLISHMENT_ID, ESA.BUSINESS_GROUP_ID, ESA.PARTY_ID, ESA.LAST_UPDATE_DATE, ESA.LAST_UPDATED_BY, ESA.CREATED_BY, ESA.CREATION_DATE, CASE WHEN ESA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ESA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_ESTABLISHMENT_ATTENDANCES ESA WITH READ ONLY

View Text - HTML Formatted

SELECT ESA.ATTENDED_START_DATE
, ESA.FULL_TIME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ESA.FULL_TIME)
, ESA.ATTENDED_END_DATE
, ESA.ESTABLISHMENT
, ESA.ADDRESS
, '_DF:PER:PER_ESTABLISHMENT_ATTENDANCES:ESA'
, ESA.ATTENDANCE_ID
, ESA.PERSON_ID
, ESA.ESTABLISHMENT_ID
, ESA.BUSINESS_GROUP_ID
, ESA.PARTY_ID
, ESA.LAST_UPDATE_DATE
, ESA.LAST_UPDATED_BY
, ESA.CREATED_BY
, ESA.CREATION_DATE
, CASE WHEN ESA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ESA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ESTABLISHMENT_ATTENDANCES ESA WITH READ ONLY