APPS.AP_NOTES_PVT dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 159: l_approval_type AP_EXPENSE_REPORT_HEADERS_ALL.APPROVAL_TYPE%TYPE;

155: p_source_object_id IN NUMBER
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;

Line 165: FROM AP_EXPENSE_REPORT_HEADERS_ALL

161: BEGIN
162: BEGIN
163: l_display_name := NULL;
164: SELECT approval_type INTO l_approval_type
165: FROM AP_EXPENSE_REPORT_HEADERS_ALL
166: WHERE report_header_id = p_source_object_id;
167:
168: -- Bug 13696856: Author should be shown in the approval notes
169: IF(NVL(l_approval_type, 'PER') <> 'PER') THEN