DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on WF_PROCESS_ACTIVITIES

Line 1917: , WF_PROCESS_ACTIVITIES PA

1913: -- , WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE,
1914: -- , WIAS.ERROR_STACK
1915: into x_activity_status
1916: from WF_ITEM_ACTIVITY_STATUSES WIAS
1917: , WF_PROCESS_ACTIVITIES PA
1918: , WF_ACTIVITIES A
1919: where WIAS.ITEM_TYPE = p_item_type
1920: and WIAS.ITEM_KEY = p_item_key
1921: and WIAS.PROCESS_ACTIVITY = PA.INSTANCE_ID

Line 9611: wf_process_activities wfpa,

9607: cursor result_codes is
9608: select wfl.lookup_code result_code
9609: from wf_lookups wfl,
9610: wf_activities wfa,
9611: wf_process_activities wfpa,
9612: wf_items wfi
9613: where wfl.lookup_type = wfa.result_type
9614: and wfa.name = wfpa.activity_name
9615: and wfi.begin_date >= wfa.begin_date

Line 10076: wf_process_activities wfpa,

10072: cursor result_codes is
10073: select wfl.lookup_code result_code
10074: from wf_lookups wfl,
10075: wf_activities wfa,
10076: wf_process_activities wfpa,
10077: wf_items wfi
10078: where wfl.lookup_type = wfa.result_type
10079: and wfa.name = wfpa.activity_name
10080: and wfi.begin_date >= wfa.begin_date