DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on HR_ALL_POSITIONS_F_TL

Line 261: , (SELECT NAME FROM HR_ALL_POSITIONS_F_TL HAPFT WHERE HAPFT.POSITION_ID = paaf.POSITION_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
263: , JOB_ID
264: , (SELECT NAME FROM PER_JOBS_TL PJT WHERE PJT.JOB_ID = paaf.JOB_ID AND LANGUAGE = USERENV('LANG')) JOB_DESC
265: , PAAF.ASSIGNMENT_STATUS_TYPE_ID