DBA Data[Home] [Help]

APPS.GMA_WFSTD_P dependencies on GMA_ACTDEF_WF

Line 155: FROM gma_actdef_wf

151: p_role:= 'ERROR';
152: END IF;
153:
154: SELECT activity_id into l_activity_id
155: FROM gma_actdef_wf
156: WHERE wf_item_type = p_wf_item_type AND
157: process_name = p_process_name AND
158: activity_name = p_activity_name;
159:

Line 901: FROM gma_actdef_wf

897: l_enable_flag := 'E';
898: END IF;
899:
900: SELECT activity_id into l_activity_id
901: FROM gma_actdef_wf
902: WHERE wf_item_type = p_wf_item_type AND
903: process_name = p_process_name AND
904: activity_name = p_activity_name;
905:

Line 1243: FROM GMA_ACTDEF_WF

1239: WHERE WF_ITEM_TYPE = P_WF_ITEM_TYPE AND
1240: PROCESS_NAME = p_PROCESS_NAME;
1241: ELSE
1242: SELECT column_data_sql,activity_id into l_sql_stmt,l_activity_id
1243: FROM GMA_ACTDEF_WF
1244: WHERE WF_ITEM_TYPE = P_WF_ITEM_TYPE AND
1245: PROCESS_NAME = p_PROCESS_NAME AND
1246: ACTIVITY_NAME= P_ACTIVITY_NAME;
1247: END IF;