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
70: and a.assignment_type in ('E', 'C')
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
108: and a.assignment_type in ('E', 'C')