APPS.OKC_DELIVERABLE_WF_PVT dependencies on PER_PEOPLE_F

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

87: -- Function returns the role name of the employee with ID p_employee_id
88: -- If the employee has no FND_USER entry, it will create an adhoc role with the
89: -- employee's email address and return that adhoc role name.
90: --Parameters:
91: --p_employee_id : PERSON ID from PER_PEOPLE_F hr_employees_current_v
92: --Testing:
93: --
94: --End of Comments
95: -------------------------------------------------------------------------------

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

97: FUNCTION get_internal_user_role(p_employee_id IN NUMBER,
98: x_role_display_name OUT NOCOPY VARCHAR2) RETURN VARCHAR2
99:
100: IS
101: --bug#4694703 replaced hr_employees_current_v with PER_PEOPLE_F
102: cursor C_user_email(x_employee_id NUMBER) is
103: select email_address, full_name from PER_PEOPLE_F where person_id = x_employee_id;
104:
105: l_role_name wf_roles.name%TYPE;

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

99:
100: IS
101: --bug#4694703 replaced hr_employees_current_v with PER_PEOPLE_F
102: cursor C_user_email(x_employee_id NUMBER) is
103: select email_address, full_name from PER_PEOPLE_F where person_id = x_employee_id;
104:
105: l_role_name wf_roles.name%TYPE;
106: l_role_display_name wf_roles.display_name%TYPE;
107:

Line 108: l_email per_people_f.email_address%TYPE;

104:
105: l_role_name wf_roles.name%TYPE;
106: l_role_display_name wf_roles.display_name%TYPE;
107:
108: l_email per_people_f.email_address%TYPE;
109: l_full_name per_people_f.full_name%TYPE;
110:
111: l_api_name CONSTANT VARCHAR2(30) :='get_internal_user_role';
112:

Line 109: l_full_name per_people_f.full_name%TYPE;

105: l_role_name wf_roles.name%TYPE;
106: l_role_display_name wf_roles.display_name%TYPE;
107:
108: l_email per_people_f.email_address%TYPE;
109: l_full_name per_people_f.full_name%TYPE;
110:
111: l_api_name CONSTANT VARCHAR2(30) :='get_internal_user_role';
112:
113: BEGIN