eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_POS_STRUCTURE_ELEMENTS_PKG dependencies on PER_ALL_PEOPLE_F

Line 65: from per_all_people_f p

61: -- Bug fix 3681825: Distinct added to sql to avoid counting the same holder more
62: -- than once.
63: select COUNT(DISTINCT P.PERSON_ID), '** ' || COUNT(DISTINCT P.PERSON_ID) ||' '||l_message
64: into X_No_Holders , l_message
65: from per_all_people_f p
66: , per_all_assignments_f a
67: where a.position_id = X_Position_Id
68: and a.business_group_id + 0 = X_Business_Group_Id
69: and a.organization_id = X_Organization_id

Line 103: from per_all_people_f p

99: (X_Session_date, p.person_id) user_person_type
100: into X_Holder
101: ,X_Employee_Number
102: ,X_User_Person_type
103: from per_all_people_f p
104: ,per_all_assignments_f a
105: where a.position_id = X_Position_Id
106: and a.business_group_id = X_Business_Group_Id
107: and a.organization_id = X_Organization_id