APPS.AP_NOTES_PVT dependencies on WF_ROLES

Line 160: l_display_name WF_ROLES.DISPLAY_NAME%TYPE;

156: )
157: RETURN VARCHAR2
158: IS
159: l_approval_type AP_EXPENSE_REPORT_HEADERS_ALL.APPROVAL_TYPE%TYPE;
160: l_display_name WF_ROLES.DISPLAY_NAME%TYPE;
161: BEGIN
162: BEGIN
163: l_display_name := NULL;
164: SELECT approval_type INTO l_approval_type

Line 172: FROM wf_roles

168: -- Bug 13696856: Author should be shown in the approval notes
169: IF(NVL(l_approval_type, 'PER') <> 'PER') THEN
170: SELECT display_name
171: INTO l_display_name
172: FROM wf_roles
173: WHERE orig_system = l_approval_type
174: AND orig_system_id = p_user_id
175: AND rownum = 1;
176: END IF;