APPS.OKC_DELIVERABLE_WF_PVT dependencies on PER_PEOPLE_F

Line 106: --p_employee_id : PERSON ID from PER_PEOPLE_F hr_employees_current_v

102: -- Function returns the role name of the employee with ID p_employee_id
103: -- If the employee has no FND_USER entry, it will create an adhoc role with the
104: -- employee's email address and return that adhoc role name.
105: --Parameters:
106: --p_employee_id : PERSON ID from PER_PEOPLE_F hr_employees_current_v
107: --Testing:
108: --
109: --End of Comments
110: -------------------------------------------------------------------------------

Line 116: --bug#4694703 replaced hr_employees_current_v with PER_PEOPLE_F

112: FUNCTION get_internal_user_role(p_employee_id IN NUMBER,
113: x_role_display_name OUT NOCOPY VARCHAR2) RETURN VARCHAR2
114:
115: IS
116: --bug#4694703 replaced hr_employees_current_v with PER_PEOPLE_F
117: cursor C_user_email(x_employee_id NUMBER) is
118: select email_address, full_name from PER_PEOPLE_F where person_id = x_employee_id;
119:
120: l_role_name wf_roles.name%TYPE;

Line 118: select email_address, full_name from PER_PEOPLE_F where person_id = x_employee_id;

114:
115: IS
116: --bug#4694703 replaced hr_employees_current_v with PER_PEOPLE_F
117: cursor C_user_email(x_employee_id NUMBER) is
118: select email_address, full_name from PER_PEOPLE_F where person_id = x_employee_id;
119:
120: l_role_name wf_roles.name%TYPE;
121: l_role_display_name wf_roles.display_name%TYPE;
122:

Line 123: l_email per_people_f.email_address%TYPE;

119:
120: l_role_name wf_roles.name%TYPE;
121: l_role_display_name wf_roles.display_name%TYPE;
122:
123: l_email per_people_f.email_address%TYPE;
124: l_full_name per_people_f.full_name%TYPE;
125:
126: l_api_name CONSTANT VARCHAR2(30) :='get_internal_user_role';
127:

Line 124: l_full_name per_people_f.full_name%TYPE;

120: l_role_name wf_roles.name%TYPE;
121: l_role_display_name wf_roles.display_name%TYPE;
122:
123: l_email per_people_f.email_address%TYPE;
124: l_full_name per_people_f.full_name%TYPE;
125:
126: l_api_name CONSTANT VARCHAR2(30) :='get_internal_user_role';
127:
128: BEGIN