DBA Data[Home] [Help]

APPS.HR_360_MESSAGE dependencies on PER_ALL_ASSIGNMENTS_F

Line 207: PER_ALL_ASSIGNMENTS_F PA,

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

Line 339: FROM per_all_assignments_f papf , per_all_people_f ppf ,

335: CURSOR CSR_REPORTEES_DATA IS
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