VIEW: APPS.HRFV_SCHOOL_COLL_ATTENDANCES

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,peo.full_name person_name ,NVL(pe.name,pea.establishment) school_or_college_name ,pea.attended_start_date start_date ,pea.attended_end_date end_date ,hr_bis.bis_decode_lookup('YES_NO',pea.full_time) full_time ,'_DF:PER:PER_ESTABLISHMENT_ATTENDANCES:pea' ,'_DF:PER:Establishment Developer DF:pe' ,pea.business_group_id business_group_id ,pea.person_id person_id ,pe.establishment_id school_or_college_id FROM hr_all_organization_units_tl bgrT ,per_people_x peo ,per_establishments pe ,per_establishment_attendances pea WHERE pea.establishment_id = pe.establishment_id(+) AND pea.person_id = peo.person_id AND pea.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND pea.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,pea.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, NVL(PE.NAME
, PEA.ESTABLISHMENT) SCHOOL_OR_COLLEGE_NAME
, PEA.ATTENDED_START_DATE START_DATE
, PEA.ATTENDED_END_DATE END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEA.FULL_TIME) FULL_TIME
, '_DF:PER:PER_ESTABLISHMENT_ATTENDANCES:PEA'
, '_DF:PER:ESTABLISHMENT DEVELOPER DF:PE'
, PEA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEA.PERSON_ID PERSON_ID
, PE.ESTABLISHMENT_ID SCHOOL_OR_COLLEGE_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PEO
, PER_ESTABLISHMENTS PE
, PER_ESTABLISHMENT_ATTENDANCES PEA
WHERE PEA.ESTABLISHMENT_ID = PE.ESTABLISHMENT_ID(+)
AND PEA.PERSON_ID = PEO.PERSON_ID
AND PEA.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PEA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEA.BUSINESS_GROUP_ID) WITH READ ONLY