APPS.GMD_OPERATION_RESOURCES_PUB dependencies on GMD_OPERATIONS

Line 139: FROM gmd_operations a, gmd_operation_activities b

135: WHERE oprn_line_id = V_oprn_line_id;
136:
137: CURSOR fetch_proc_uom (V_oprn_line_id NUMBER) IS
138: SELECT process_qty_uom
139: FROM gmd_operations a, gmd_operation_activities b
140: WHERE a.oprn_id = b.oprn_id
141: AND b.oprn_line_id = V_oprn_line_id;
142:
143: CURSOR get_resource_det (V_resources VARCHAR2) IS

Line 496: v_oprn_id gmd_operations.oprn_id%TYPE;

492: , x_message_count OUT NOCOPY NUMBER
493: , x_message_list OUT NOCOPY VARCHAR2
494: , x_return_status OUT NOCOPY VARCHAR2) IS
495:
496: v_oprn_id gmd_operations.oprn_id%TYPE;
497: l_return_status VARCHAR2(1);
498: l_api_version NUMBER := 1.0;
499: l_exist NUMBER(5);
500: