DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 214: , USER_STATUS PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE

210: , POSITION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE --(BASED ON LANG)
211: , JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE
212: , JOB_DESC PER_JOBS_TL.NAME%TYPE --(BASED ON LANG)
213: , ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE
214: , USER_STATUS PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
215: , PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE
216: , PER_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PER_SYSTEM_STATUS%TYPE
217: , PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE
218: , PAYROLL_DESC PAY_PAYROLLS_F.PAYROLL_NAME%TYPE

Line 215: , PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE

211: , JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE
212: , JOB_DESC PER_JOBS_TL.NAME%TYPE --(BASED ON LANG)
213: , ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE
214: , USER_STATUS PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
215: , PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE
216: , PER_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PER_SYSTEM_STATUS%TYPE
217: , PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE
218: , PAYROLL_DESC PAY_PAYROLLS_F.PAYROLL_NAME%TYPE
219: , LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE

Line 216: , PER_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PER_SYSTEM_STATUS%TYPE

212: , JOB_DESC PER_JOBS_TL.NAME%TYPE --(BASED ON LANG)
213: , ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE
214: , USER_STATUS PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
215: , PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE
216: , PER_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PER_SYSTEM_STATUS%TYPE
217: , PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE
218: , PAYROLL_DESC PAY_PAYROLLS_F.PAYROLL_NAME%TYPE
219: , LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE
220: , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)

Line 1243: REPORTEE_ASG_STATUS_DESC PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE

1239: REPORTEE_APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
1240: REPORTEE_LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
1241: REPORTEE_LOCATION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE, --(BASED ON LANG)E,
1242: REPORTEE_ASG_STATUS_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE,
1243: REPORTEE_ASG_STATUS_DESC PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
1244: );
1245:
1246: TYPE ABSENCE_DETAILS IS RECORD
1247: (