APPS.GMD_STATUS_PUB dependencies on GMD_ROUTINGS_B

Line 173: FROM gmd_routings_b

169: CURSOR get_curr_routing_status(vrouting_id NUMBER
170: ,vrouting_no VARCHAR2
171: ,vrouting_vers NUMBER) IS
172: SELECT routing_id, routing_no, routing_vers, routing_status
173: FROM gmd_routings_b
174: WHERE ((vrouting_no IS NULL AND vrouting_vers IS NULL) AND
175: (routing_id = vrouting_id)) OR
176: ((vrouting_id IS NULL) AND
177: (routing_no = vrouting_no AND routing_vers = vrouting_vers));

Line 947: 'ROUTING','GMD_ROUTINGS_B',

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
949: FROM sys.dual;
950: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
951: 'TABLE_NAME',l_table_name,