DBA Data[Home] [Help]

APPS.GMDFMLAP_WF_PKG dependencies on GMD_RECIPE_GENERATION

Line 277: FROM gmd_recipe_generation

273: /* Bug 3748697 - Recipe should only be created for automatic */
274: /* or optional setup */
275: CURSOR cur_recipe_enable (V_orgn_id VARCHAR2) IS
276: SELECT creation_type
277: FROM gmd_recipe_generation
278: WHERE organization_id = V_orgn_id
279: AND creation_type IN (1,2)
280: UNION
281: SELECT creation_type

Line 282: FROM gmd_recipe_generation

278: WHERE organization_id = V_orgn_id
279: AND creation_type IN (1,2)
280: UNION
281: SELECT creation_type
282: FROM gmd_recipe_generation
283: WHERE organization_id IS NULL
284: AND creation_type IN (1,2)
285: AND NOT EXISTS (SELECT 1
286: FROM gmd_recipe_generation

Line 286: FROM gmd_recipe_generation

282: FROM gmd_recipe_generation
283: WHERE organization_id IS NULL
284: AND creation_type IN (1,2)
285: AND NOT EXISTS (SELECT 1
286: FROM gmd_recipe_generation
287: WHERE organization_id = V_orgn_id);
288: l_creation_type NUMBER(5);
289:
290: BEGIN