DBA Data[Home] [Help]

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)