APPS.AP_WEB_OA_ACTIVE_PKG dependencies on WF_PROCESS_ACTIVITIES
Line 186: WF_PROCESS_ACTIVITIES PA
182: INTO v_activity_label
183: FROM (
184: SELECT PA.INSTANCE_LABEL
185: FROM WF_ITEM_ACTIVITY_STATUSES IAS, 186: WF_PROCESS_ACTIVITIES PA 187: WHERE
188: IAS.ITEM_TYPE = C_APEXP
189: AND IAS.ACTIVITY_STATUS = C_NOTIFIED
190: AND IAS.ITEM_KEY = TO_CHAR(p_report_header_id)