DBA Data[Home] [Help]

APPS.PA_UTILS3 dependencies on PER_ALL_PEOPLE_F

Line 215: --FP M To reduce dependency on HR, changing the per_people_x to per_all_people_f

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

Line 218: Per_All_People_F P,

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

Line 599: Per_All_People_F P,

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