APPS.AP_WEB_OA_ACTIVE_PKG dependencies on WF_PROCESS_ACTIVITIES

Line 177: WF_PROCESS_ACTIVITIES PA

173: INTO v_activity_label
174: FROM (
175: SELECT PA.INSTANCE_LABEL
176: FROM WF_ITEM_ACTIVITY_STATUSES IAS,
177: WF_PROCESS_ACTIVITIES PA
178: WHERE
179: IAS.ITEM_TYPE = C_APEXP
180: AND IAS.ACTIVITY_STATUS = C_NOTIFIED
181: AND IAS.ITEM_KEY = TO_CHAR(p_report_header_id)