DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PER_GRADES_TL

Line 258: , (SELECT NAME FROM PER_GRADES_TL PGT WHERE PGT.GRADE_ID = paaf.GRADE_ID

254: , to_char(PAAF.EFFECTIVE_START_DATE,'YYYY-MM-DD')
255: , to_char(PAAF.EFFECTIVE_END_DATE,'YYYY-MM-DD')
256: , RECRUITER_ID
257: , GRADE_ID
258: , (SELECT NAME FROM PER_GRADES_TL PGT WHERE PGT.GRADE_ID = paaf.GRADE_ID
259: AND LANGUAGE = USERENV('LANG')) GRADE_DESC
260: , POSITION_ID
261: , (SELECT NAME FROM HR_ALL_POSITIONS_F_TL HAPFT WHERE HAPFT.POSITION_ID = paaf.POSITION_ID
262: AND LANGUAGE = USERENV('LANG')) POSITION_DESC