APPS.AP_WEB_OA_ACTIVE_PKG dependencies on WF_ROLES

Line 48: --Bug 12565659: Fetch the approver name directly from wf_roles, to display it correctly

44: WF_ENGINE.GetItemAttrText(C_APEXP, TO_CHAR(p_report_header_id), p_attribute_name);
45: gan_old_report_header_id := p_report_header_id;
46: gan_old_attribute_name := p_attribute_name;
47:
48: --Bug 12565659: Fetch the approver name directly from wf_roles, to display it correctly
49: IF p_attribute_name = C_APPROVER_DISPLAY_NAME THEN
50: SELECT wfr.description INTO gan_old_approver_name
51: FROM ap_expense_report_headers_all aerh, wf_roles wfr
52: WHERE aerh.report_header_id = p_report_header_id

Line 51: FROM ap_expense_report_headers_all aerh, wf_roles wfr

47:
48: --Bug 12565659: Fetch the approver name directly from wf_roles, to display it correctly
49: IF p_attribute_name = C_APPROVER_DISPLAY_NAME THEN
50: SELECT wfr.description INTO gan_old_approver_name
51: FROM ap_expense_report_headers_all aerh, wf_roles wfr
52: WHERE aerh.report_header_id = p_report_header_id
53: AND wfr.orig_system = aerh.approval_type
54: AND wfr.orig_system_id = aerh.expense_current_approver_id;
55: END IF;