211: Into
212: X_Inc_By_Per_Number,
213: X_Business_Group_Name
214: From
215: --FP M To reduce dependency on HR, changing the per_people_x to per_all_people_f
216: --and added the date check
217: --Per_People_X P,
218: Per_All_People_F P,
219: Hr_Organization_Units O
214: From
215: --FP M To reduce dependency on HR, changing the per_people_x to per_all_people_f
216: --and added the date check
217: --Per_People_X P,
218: Per_All_People_F P,
219: Hr_Organization_Units O
220: Where
221: P.Person_Id = P_Inc_By_Per_Id
222: and O.Organization_Id = P.Business_Group_Id
595: MAX(P.Employee_Number)
596: Into
597: l_emp_Number
598: From
599: Per_All_People_F P,
600: Hr_Organization_Units O
601: Where
602: P.Person_Id = P_Person_Id
603: and O.Organization_Id = P.Business_Group_Id