DBA Data[Home] [Help]

APPS.GMD_STATUS_PUB dependencies on FM_FORM_MST_B

Line 158: FROM fm_form_mst_b

154: CURSOR get_curr_formula_status(vformula_id NUMBER
155: ,vformula_no VARCHAR2
156: ,vformula_vers NUMBER) IS
157: SELECT formula_id, formula_no, formula_vers, formula_status
158: FROM fm_form_mst_b
159: WHERE ((vformula_no IS NULL AND vformula_vers IS NULL) AND
160: (formula_id = vformula_id)) OR
161: ((vformula_id IS NULL) AND
162: (formula_no = vformula_no AND formula_vers = vformula_vers));

Line 938: 'FORMULA','FM_FORM_MST_B',

934: IF (l_debug = 'Y') THEN
935: gmd_debug.put_line ('In locked exception section ');
936: END IF;
937: SELECT DECODE(P_entity_name,
938: 'FORMULA','FM_FORM_MST_B',
939: 'RECIPE','GMD_RECIPES_B',
940: 'OPERATION','GMD_OPERATIONS_B',
941: 'ROUTING','GMD_ROUTINGS_B',
942: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES') INTO l_table_name