APPS.PQH_SS_WORKFLOW dependencies on WF_PROCESS_ACTIVITIES

Line 432: FROM wf_process_activities PA,

428: and ias.item_key = p_itemKey
429: and ias.activity_status = 'NOTIFIED'
430: and ias.process_activity in (
431: select pa.instance_id
432: FROM wf_process_activities PA,
433: wf_activity_attributes AA,
434: wf_activities WA,
435: wf_items WI
436: WHERE pa.process_item_type = ias.item_type

Line 459: FROM WF_PROCESS_ACTIVITIES WPA,

455: and ias.item_key = p_itemKey
456: and ias.activity_status = 'NOTIFIED'
457: and ias.process_activity in (
458: select wpa.instance_id
459: FROM WF_PROCESS_ACTIVITIES WPA,
460: WF_ACTIVITY_ATTRIBUTES WAA,
461: WF_ACTIVITIES WA,
462: WF_ITEMS WI
463: WHERE wpa.process_item_type = ias.item_type

Line 519: WF_PROCESS_ACTIVITIES PA

515:
516: CURSOR c_wf IS
517: SELECT instance_label,ias.process_activity actvityId, ias.notification_id ntfId
518: FROM WF_ITEM_ACTIVITY_STATUSES IAS,
519: WF_PROCESS_ACTIVITIES PA
520: WHERE IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
521: AND ias.item_type = pa.process_item_type
522: and ias.item_type = p_itemType
523: and ias.item_key = p_itemKey

Line 3458: WF_PROCESS_ACTIVITIES PA,

3454: A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE,
3455: IAS.BEGIN_DATE, IAS.EXECUTION_TIME
3456: from WF_ITEM_ACTIVITY_STATUSES IAS,
3457: WF_ACTIVITIES A,
3458: WF_PROCESS_ACTIVITIES PA,
3459: WF_ITEM_TYPES IT,
3460: WF_ITEMS I
3461: where IAS.ITEM_TYPE = x_item_type
3462: and IAS.ITEM_KEY = x_item_key

Line 3479: WF_PROCESS_ACTIVITIES PA,

3475: A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE,
3476: IAS.BEGIN_DATE, IAS.EXECUTION_TIME
3477: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
3478: WF_ACTIVITIES A,
3479: WF_PROCESS_ACTIVITIES PA,
3480: WF_ITEM_TYPES IT,
3481: WF_ITEMS I
3482: where IAS.ITEM_TYPE = x_item_type
3483: and IAS.ITEM_KEY = x_item_key