APPS.HR_360_MESSAGE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 214: PER_ASSIGNMENT_STATUS_TYPES ST ,

210: PER_GRADES_TL GDT,
211: PER_JOBS_TL JBT ,
212: HR_LOCATIONS_ALL_TL LOCTL,
213: HR_LOCATIONS_ALL LOC,
214: PER_ASSIGNMENT_STATUS_TYPES ST ,
215: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
216: PER_ASS_STATUS_TYPE_AMENDS AMD,
217: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL,
218: HR_ALL_ORGANIZATION_UNITS O,

Line 215: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,

211: PER_JOBS_TL JBT ,
212: HR_LOCATIONS_ALL_TL LOCTL,
213: HR_LOCATIONS_ALL LOC,
214: PER_ASSIGNMENT_STATUS_TYPES ST ,
215: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
216: PER_ASS_STATUS_TYPE_AMENDS AMD,
217: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL,
218: HR_ALL_ORGANIZATION_UNITS O,
219: HR_ALL_ORGANIZATION_UNITS_TL OTL ,

Line 340: PER_ASSIGNMENT_STATUS_TYPES ST ,

336:
337: SELECT ppf.full_name, employee_number ,
338: NVL(AMDTL.USER_STATUS , STTL.USER_STATUS) ASSIGNMENT_STATUS
339: FROM per_all_assignments_f papf , per_all_people_f ppf ,
340: PER_ASSIGNMENT_STATUS_TYPES ST ,
341: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
342: PER_ASS_STATUS_TYPE_AMENDS AMD,
343: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL
344:

Line 341: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,

337: SELECT ppf.full_name, employee_number ,
338: NVL(AMDTL.USER_STATUS , STTL.USER_STATUS) ASSIGNMENT_STATUS
339: FROM per_all_assignments_f papf , per_all_people_f ppf ,
340: PER_ASSIGNMENT_STATUS_TYPES ST ,
341: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
342: PER_ASS_STATUS_TYPE_AMENDS AMD,
343: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL
344:
345: WHERE