DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on HR_ALL_POSITIONS_F_TL

Line 280: , (SELECT NAME FROM HR_ALL_POSITIONS_F_TL HAPFT WHERE HAPFT.POSITION_ID = paaf.POSITION_ID

276: , GRADE_ID
277: , (SELECT NAME FROM PER_GRADES_TL PGT WHERE PGT.GRADE_ID = paaf.GRADE_ID
278: AND LANGUAGE = USERENV('LANG')) GRADE_DESC
279: , POSITION_ID
280: , (SELECT NAME FROM HR_ALL_POSITIONS_F_TL HAPFT WHERE HAPFT.POSITION_ID = paaf.POSITION_ID
281: AND LANGUAGE = USERENV('LANG')) POSITION_DESC
282: , JOB_ID
283: , (SELECT NAME FROM PER_JOBS_TL PJT WHERE PJT.JOB_ID = paaf.JOB_ID AND LANGUAGE = USERENV('LANG')) JOB_DESC
284: , PAAF.ASSIGNMENT_STATUS_TYPE_ID