DBA Data[Home] [Help]

APPS.GMD_STATUS_PUB dependencies on FM_FORM_MST_B

Line 162: FROM fm_form_mst_b

158: CURSOR get_curr_formula_status(vformula_id NUMBER
159: ,vformula_no VARCHAR2
160: ,vformula_vers NUMBER) IS
161: SELECT formula_id, formula_no, formula_vers, formula_status
162: FROM fm_form_mst_b
163: WHERE ((vformula_no IS NULL AND vformula_vers IS NULL) AND
164: (formula_id = vformula_id)) OR
165: ((vformula_id IS NULL) AND
166: (formula_no = vformula_no AND formula_vers = vformula_vers));

Line 944: 'FORMULA','FM_FORM_MST_B',

940: IF (l_debug = 'Y') THEN
941: gmd_debug.put_line ('In locked exception section ');
942: END IF;
943: SELECT DECODE(P_entity_name,
944: 'FORMULA','FM_FORM_MST_B',
945: 'RECIPE','GMD_RECIPES_B',
946: 'OPERATION','GMD_OPERATIONS_B',
947: 'ROUTING','GMD_ROUTINGS_B',
948: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES') INTO l_table_name