DBA Data[Home] [Help]

APPS.GMDFMGAP_WF_PKG dependencies on GMD_RECIPE_GENERATION

Line 285: FROM gmd_recipe_generation

281: /* Bug 3748697 - Recipe should only be created for automatic */
282: /* or optional setup */
283: CURSOR cur_recipe_enable (V_orgn_id NUMBER) IS
284: SELECT creation_type
285: FROM gmd_recipe_generation
286: WHERE organization_id = V_orgn_id
287: AND creation_type IN (1,2)
288: UNION
289: SELECT creation_type

Line 290: FROM gmd_recipe_generation

286: WHERE organization_id = V_orgn_id
287: AND creation_type IN (1,2)
288: UNION
289: SELECT creation_type
290: FROM gmd_recipe_generation
291: WHERE organization_id IS NULL
292: AND creation_type IN (1,2)
293: AND NOT EXISTS (SELECT 1
294: FROM gmd_recipe_generation

Line 294: FROM gmd_recipe_generation

290: FROM gmd_recipe_generation
291: WHERE organization_id IS NULL
292: AND creation_type IN (1,2)
293: AND NOT EXISTS (SELECT 1
294: FROM gmd_recipe_generation
295: WHERE organization_id = V_orgn_id);
296: l_creation_type NUMBER(5);
297: BEGIN
298: IF (p_funcmode = 'RUN') THEN