[Home] [Help]
View: HRFV_SCHOOL_COLL_ATTENDANCES
Product: | PER - Human Resources |
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
APPS.HRFV_SCHOOL_COLL_ATTENDANCES
|
View Text
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PE.NAME 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'
, 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
Columns
Name |
BUSINESS_GROUP_NAME |
PERSON_NAME |
SCHOOL_OR_COLLEGE_NAME |
START_DATE |
END_DATE |
FULL_TIME |
"_DF" |
BUSINESS_GROUP_ID |
PERSON_ID |
SCHOOL_OR_COLLEGE_ID |