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 9687: wf_process_activities wfpa,

9683: cursor result_codes is
9684: select wfl.lookup_code result_code
9685: from wf_lookups wfl,
9686: wf_activities wfa,
9687: wf_process_activities wfpa,
9688: wf_items wfi
9689: where wfl.lookup_type = wfa.result_type
9690: and wfa.name = wfpa.activity_name
9691: and wfi.begin_date >= wfa.begin_date

Line 10152: wf_process_activities wfpa,

10148: cursor result_codes is
10149: select wfl.lookup_code result_code
10150: from wf_lookups wfl,
10151: wf_activities wfa,
10152: wf_process_activities wfpa,
10153: wf_items wfi
10154: where wfl.lookup_type = wfa.result_type
10155: and wfa.name = wfpa.activity_name
10156: and wfi.begin_date >= wfa.begin_date