DBA Data[Home] [Help]

APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPE_GENERATION

Line 1090: FROM gmd_recipe_generation

1086: WHERE formula_id = V_formula_id;
1087:
1088: CURSOR Cur_get_auto_recipe(V_orgn_id fm_form_mst_b.owner_organization_id%TYPE) IS
1089: SELECT creation_type
1090: FROM gmd_recipe_generation
1091: WHERE organization_id = V_orgn_id
1092: AND creation_type IN (1,2)
1093: UNION
1094: SELECT creation_type

Line 1095: FROM gmd_recipe_generation

1091: WHERE organization_id = V_orgn_id
1092: AND creation_type IN (1,2)
1093: UNION
1094: SELECT creation_type
1095: FROM gmd_recipe_generation
1096: WHERE organization_id IS NULL
1097: AND creation_type IN (1,2)
1098: AND NOT EXISTS (SELECT 1
1099: FROM gmd_recipe_generation

Line 1099: FROM gmd_recipe_generation

1095: FROM gmd_recipe_generation
1096: WHERE organization_id IS NULL
1097: AND creation_type IN (1,2)
1098: AND NOT EXISTS (SELECT 1
1099: FROM gmd_recipe_generation
1100: WHERE organization_id = V_orgn_id);
1101: --kkillams,bug 3738941
1102: CURSOR cur_form_att(cp_entity_name fnd_attached_documents.entity_name%TYPE,
1103: cp_pk1_value fnd_attached_documents.pk1_value%TYPE) IS