APPS.HR_360_MESSAGE dependencies on PER_ALL_ASSIGNMENTS_F

Line 210: PER_ALL_ASSIGNMENTS_F PA,

206: hr_lookups HL1 ,
207: HR_LOOKUPS HL2 ,
208: HR_LOOKUPS HL3 ,
209: HR_LOOKUPS HL4 ,
210: PER_ALL_ASSIGNMENTS_F PA,
211: PER_GRADES PG ,
212: PER_JOBS J,
213: PER_GRADES_TL GDT,
214: PER_JOBS_TL JBT ,

Line 347: FROM per_all_assignments_f papf , per_all_people_f ppf ,

343:
344: SELECT ppf.full_name,
345: decode ( ppf.CURRENT_NPW_FLAG , 'Y',ppf.NPW_NUMBER,ppf.EMPLOYEE_NUMBER) employee_number ,
346: NVL(AMDTL.USER_STATUS , STTL.USER_STATUS) ASSIGNMENT_STATUS
347: FROM per_all_assignments_f papf , per_all_people_f ppf ,
348: PER_ASSIGNMENT_STATUS_TYPES ST ,
349: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
350: PER_ASS_STATUS_TYPE_AMENDS AMD,
351: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL